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?