B.C.A-B.C.A Computer Application 4th Sem DATABASE MANAGEMENT SYSTEM(Alagappa University, Karaikudi, Tamil Nadu-2011)
Wednesday, 24 July 2013 09:38Jebaprincy
Computer Applications / Computer Science /Information Technology/Software
DATABASE MANAGEMENT SYSTEM
[Common for Computer Applications / Computer Science / Information Technology /Software]
(Non-CBCS—2004 onwards)
Time : 3 Hours Maximum : 100 Marks
Part A (10 × 1 = 10)
Answer all questions.
1. Define DBMS.
2. Define Weak entity set.
3. What is Datalog ?
4. What is QBE ?
5. When a domain is atomic ?
6. What is WORM ?
7. What is block ?
8. List out the two basic kinds of indices.
9. List out the storage types.
10. What is LAN, WAN ?
Part B (5 × 6 = 30)
Answer any five questions.
11. Explain the major components of an Entity Relationship diagram.
12. Write a short note on record-based data Models.
13. Explain Domain Constraints.
14. Explain triggers.
15. Explain object identity and pointers of a persistent object.
16. Compare Ordered indexing and Hashing.
17. Explain checkpoints.
Part C (5 × 12 = 60)
Answer any five questions.
18. Explain the Overall System structure with a diagram.
19. Explain mapping constraints.
20. Explain Functional Dependencies
21. Explain tuple relational calculus.
22. Explain Object Oriented Data model.
23. Explain organization of records in files.
24. Describe Static hashing.
25. Describe Advanced recovery techniques
| Earning: ₹ 4.45/- |
