Database Administration Importance Exam questions.

Following are the important database administration questions generally asked in the examinations.

LONG QUESTIONS

1. What is DBMS? Mention its clear architecture including its different types of files.
2. What do you mean by performance tuning? What are its importance? What are the various kinds of performance reports available in the oracle database management system?
3. Define and explain oracle server architecture.
4. Explain what do you mean by database users and security.
5. Compare and contrast control files, physical files, data files and redo log files.
6. What is VPD? Explain its importance and implementation with examples.
7. How do you multiplex:
• spfile from pfile
• redo log file
8. What are the different types of performance tuning methodology.
9. What do you mean by database security? Explain different methods and techniques invovled in database security.
10. What do you mean by roles in database? Explain its importance with examples.

SHORT QUESTIONS

1. What do you mean by SQL? Explain different types of SQL.
2. Differentiate between pfile and spfile.
3. Differentiate between system generated constraint name and user generated constraint name.
4. Differentiate between critical and non-critical recovery.
5. Define flashback recovery? Implement flashback recovery with and example.
6. What is backup and recovery? Inter relate among backup, restore and recovery.
7. What are the forms of database shutdown?
8. Differentiate between online backup and offline backup.
9. Differentiate between cold backup and hot backup.
10.  What are the roles and responsibilities of DBA.
11. What do you mean by AWR? Explain its architecture.
12. Explain state transition diagram with example.
13. What is RMAN? What steps are involved in RMAN?
14. Define profile, role and privilege. Why are they required?
15. What is view? Write importance of views?
16. What is ASM? Mention capabilities of ASM.
17. Write the command to add new redo group and drop redo group in the database.
18. What do you mean by parallel instance recovery?
19. Write a trigger to create log of every update and delete statement of product table. 
20. What are the steps involved in:
• steps to create backup device.
• internal database connector
21. What is SQL Tuning Advisor?
22. What are the importance of control files? If control files are corrupt, what is the state of database.
23. Wha are the importance of archive log file. Write down the steps to enable archive log files.
24. Write down the steps to create a redo log group with two associated members of size 10MB.
25. Explain DBMS architecture.
26. What do you mean by database independence?
27. What are the forms of database startup in oracle?