Database Administration 2070

                                                       Section A

                                  Attempt any Two questions. (2x10=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. What is tuning methodology? Explain the Automatic database diagnostic monitor with its applications.

                                          Section B

                          Attempt any Eight questions. (8x5=40)

4. Explain the database security and auditing.

5. How can you test the backup and recovery plan?

6. How can you manage the automatic storage?

7. Differentiate between database administrator and data administrator.

8. Explain the ASM and its capabilities.

9. Define the AWR. What are the components of AWR report?

10. What do you mean by parallel instance recovery?

11. What do you mean by database corruption? How can you recover in this case?

12. Explain the SQL tuning advisor.

13. Write short note on:

    a. Using ISQL Plus

    b. RMAN