B.Sc Computer Science 6th Sem MODERN DATABASE MANAGEMENT (Acharya Nagarjuna University (ANU), Guntur, Andhra Pradesh-2011).

 B.Sc. DEGREE EXAMINATION, MAY 2012.
(Examination at the end of Third Year)
Part II — Computer Science
Paper III — MODERN DATABASE MANAGEMENT
Time : Three hours Maximum : 100 marks
PART A — (3 × 20 = 60 marks)
Answer any THREE questions.
1. Discuss about database development process and three-scheme architecture.
2. What do you know about Boyce-Codd normal form and fourth normal form?
3. Write a note on :
(a) Denormalization.
(b) Optimizing for query performance.
4. Explain about roles of data and database administrators.
5. Discuss about backing up databases and concurrent access.
PART B — (4 × 5 = 20 marks)
Answer any FOUR questions.
6. Explain in brief about ACID properties of database transaction.
7. Write a short note on costs and risks of the database approach.
8. What do you know about normalization? What is the need of normalization? Explain briefly.
9. How do you update and delete in data in the database explain with example?
10. Write a short note on Triggers.
11. Explain in brief about three-tier architectures.
PART C — (10 × 2 = 20 marks)
Answer ALL questions.
12. Committed transaction.
13. State components of the database environment.
14. Define first and second normal forms.
15. Write about routines.
16. Data dictionary.
17. Data security.
18. Processing multiple tables.
19. Write a note on indexes.
20. Mainframes.
21. Dynamic SQL.