Database Administration 2076

Group A

Attempt any Two questions.(2 x 10 = 20)

1. What is profile? How is it different from user? How do you create, assign, alter, and drop profile? Explain with suitable examples. 

2. Why do we need recovery? Discuss undo and redo log files used in recovery?

3. Discuss automatic database diagnostic monitor in detail. What is SQL tuning advisor?

Group B

4. Define role. How do you query role information?

5. Define index ? Why do we need index in databases?

6. What is backup and recovery plan? How do you test this plan?

7. Discuss different policy types of virtual private database.

8. Explain DBMS architecture. What is data independence?

9. How do you produce more readable output to the result returned from SQL*Plus?Explain.

10. Define redo log file? Why do we need this file in databases?

11. How do you create different control files? Discuss.

12. What are different solutions of database corruption?

13. Write short notes on:

a) RMAN

b) Database auditing