⟩ Explain System.effective_date system variable is read only True/False?
False
False
Explain the Dual table. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get and Why?
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
Explain What are the differences between database designing and database modeling?
Explain In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
Explain How can we see the source code of the package?
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
Explain about the oracle disaster recovery scenarios?
How we remove duplicate rows in table?
How to append data in a file from one server to another server?
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?