Database Administration 2077

Group A

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

1. How do you manage user privileges and roles ? Explain using suitable examples.

2. Why do we need recovery in databases? How do you define backup and recovery procedure?

3. Explain database performance tuning. What is tuning methodology? Explain.

Group B

Attempt any Eight questions.(8 x 5 = 40)

4. What is DBMS architecture? Explain.

5. How do you manage control files? Explain.

6. What is trigger? Explain with example.

7. Why do we manage concurrency of transactions? Explain.

8. What is parallel instance recovery? Explain.

9. What are different solutions used in database corruption?

10. How does recovery manager manages automatic storage?

11. Explain different roles of automatic diagnostic monitor.

12. What is SQL tuning advisor? Explain.

13. Write short notes on:

a) stored procedure

b) AWR report