Database Administration 2069

                                                                Section A

                                        Attempt any Two questions. (2x10=20)

1. Explain the database management system and also describe the database management system architecture.

2. How can you design the plan of backup, recovery and security of an organization? Explain.

3. Explain the control and Redo log files with applications.

                                          Section B

                            Attempt any Eight questions. (8x5=40)

4. What do you mean by  SQL and PLUS? Explain.

5. Explain the advanced stored procedures.

6. Explain the testing the backup and recovery plan.

7. What do you mean by database corruption? How can you maintain the database corruption?

8. Describe the SQL Tuning Advisor with example.

9. What do you mean by virtual private database?

10. Explain the parallel instance recovery with example.

11. What do you mean by automatic storage management? Explain.

12. Explain the tuning methodology with example.

13. Write short note on:

      a. ADDM (Automatic Database Diagnostic Monitor)

      b. RMAN