Wednesday, 13 February 2013

DBA interview questions

1. How can I Export 9i data in 8i ? I mean when I Export from 9i and Import in 8i, I face errors. what sould i do?
2. How do you verify and validate the Datafile which is backed up?
3. how much time will it take a hotbackup if the batabase size is 60Gb?
4. What is mean live dead lock? How to prevent it.?
5. what is the difference between recovery and restoring of the database?
6. What are the different tools available for hot backups?
7. what is the difference between media recovery and crash recovery..?

Media recovery is a process to recover database from backup when physical disk failure occur.
Cash recovery is a automated process take care by oracle when instance failure occur.

8. what do you mean by MEDIA RECOVERY..?

Media recovery is a process of restoring the physical backups and making all the 
restored datafiles consistent with each other by having same SCN’s in their header’s.

9. what is the disk migration?what isthe steps involved in diskmigration?
10. What are the steps involved in Database Startup ?
11. What are the steps involved in Database Shutdown?
12. What is Restricted Mode of Instance Startup ?
13. What are the different modes of mounting a Database with the Parallel Server ?
14. What is Full Backup ?
15. Can Full Backup be performed when the database is open ?
16. What is Partial Backup ?
17. What is On-line Redo Log?
18. What is Mirrored on-line Redo Log ?
19. What is Archived Redo Log ?
20. What are the advantages of operating a database in ARCHIVELOG mode over operating it
21. What are the steps involved in Instance Recovery ?

No comments:

Post a Comment

Number of Visitors