Database Administration 2074

Group A

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

1. Explain the DBMS architecture and its applications.

2. Explain the process to design the backup, recovery and security plan for the government organization.

3. How can you manage, maintain and monitoring the redo log files? Explain with example.

Group B

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

4. Explain DBA roles and responsibilities.

5. Explain the Database security and auditing.

6. Explain the process of backup and recovery plan.

7. Automatic DBM.

8. Automatic DB diagnostic monitor.

9. UPDB with example.

10. Explain the process of parallel instance recovery with example.

11. Application of automatic storage management.

12. Explain the tuning methodology with example.

13. Write short notes on:

1. Triggers

2. SQL Tuning advisor