Database Administration 2075

Group A

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

1.Explain the database management system architecture and also explain the DBA roles and responsibilities.

2. What do you mean by Redo log files? Explain the maintaining and monitoring redo log files.

3. Explain Backup and recovery plan. How do you test the backup and recovery plan?

Group B

Attempt any eight questions:(8 x 5 = 40)

4. Compare SQL* plus with iSQL* plus.

5. Explain the database security and auditing.

6. Manage user in dB.

7. Explain parallel instance recovery.

8. Difference between automatic dBM and ASM.

9. Discuss Automatic DB diagnostic monitor.

10. Performance tuning with example.

11. Explain UPDB with example.

12. Process to maintain the dB corruption.

13. Write short notes on:

a. User privilage

b. SQL tuning advisor