DBA Interview Questions
1)Why is a UNION ALL faster than a UNION?
2)What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?
3)What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?
4)Describe the Oracle Wait Interface, how it works, and what it provides. What are some limitations? What do the db_file_sequential_read and db_file_scattered_read events indicate?
5)How do you return the top-N results of a query in Oracle? Why doesn’t the obvious method work?
6)Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync?
Showing posts with label dba. Show all posts
Showing posts with label dba. Show all posts
DBA Interview -Backup Recovery
DBA Interview -Backup Recovery
1)Explain partial backup.
2)Difference between partial backup and full backup.
3)Describe full backup.
4)How does database shutdown take place?
5)How does database startup take place?
6)Describe the various steps in Instance Recovery.
7)What do you mean by On-line Redo Log?
8)What do you mean by Archived Redo Log?
9)What is meant by Mirrored Online Redo Log?
10)Various modes used in mounting a database with a Parallel Server.
11)How do we perform a full backup in an open database?
12)Explain the Restricted Mode of Instance Startup.
13)What do you understand by Log Switch?
14)Why do we prefer to operate a database in ARCHIVELOG mode than NO ARCHIVELOG mode?
15)How does Instance Recovery take place?
16)How do we make the recovery using missing online redo logs?
17)How can we recover a missing data file?
1)Explain partial backup.
2)Difference between partial backup and full backup.
3)Describe full backup.
4)How does database shutdown take place?
5)How does database startup take place?
6)Describe the various steps in Instance Recovery.
7)What do you mean by On-line Redo Log?
8)What do you mean by Archived Redo Log?
9)What is meant by Mirrored Online Redo Log?
10)Various modes used in mounting a database with a Parallel Server.
11)How do we perform a full backup in an open database?
12)Explain the Restricted Mode of Instance Startup.
13)What do you understand by Log Switch?
14)Why do we prefer to operate a database in ARCHIVELOG mode than NO ARCHIVELOG mode?
15)How does Instance Recovery take place?
16)How do we make the recovery using missing online redo logs?
17)How can we recover a missing data file?
Subscribe to:
Posts (Atom)
