Interview Questions

1. How do you move the tablespaces or datafiles from one server to another server with archivelog mode.
2. How do you copy database from production to new server using RMAN.
3. Session hangs, user unable to connect the database, what is your analysis and how do you resolve it.
4. Archive destination is full 100%,database hangs and configured RMAN, how do you resolve the issues.
5. What is LOCAL LISTENER, how does it work.
6. You have created one index on Primary database, how do you check whether it is avaliable on Standby database.
7. If you change SYS password on Primary database, will standby database work.
8. When you fire (DML) statement, what is doing oracle archicture.
9. If you add datafiles on primary database, what will happend on standy database. What parameter is required and What will happend if you set AUTO or Manual
10. How do you apply critical patch.