Database Administration 2073

                                                              Section A

                                          Attempt any Two questions. (2x10=20)

1. What do you mean by Database and database management system? Explain the SQL Plus overview.

2. Explain the managing, maintaining and monitoring redo log files with appropriate example.

3. Explain the backup and recovery plan and strategy with practical example.

                                                    Section B

                                Attempt any Eight questions. (8x5=40)

4. How can you manage the control files? Explain.

5. Explain the database security and auditing.

6. Explain the testing the backup and recovery plan.

7. What do you mean by backup and recovery strategy?

8. Explain the RMAN with example.

9. What do you mean by tuning methodology?

10. Explain the virtual private database with example.

11. Explain the parallel instance recovery with practical example.

12. What are the major difference between automatic database management and automatic storage management?

13. Write short note on:

    a) DBA roles

    b) Column masking