Madras University (UnOM) 2007 B.C.A Computer Application Database Management Systems - Question Paper

M.O.P. VAISHNAV COLLEGE FOR WOMEN [AUTONOMOUS]


part A (15 x two = 30)

ans all ques.

1. What do you mean by Data Inconsistency?

2. Give the expansion of E-R model and XML.

3. Define Mapping Cardinalities.

4. What is a primary key?

5. What is an assignment operation in relational algebra?

6. Define a view.

7. What is a Tuple?

8. What is dynamic SQL?

9. Define group by clause.

10. Mention a few integrity constraints.

11. What is alteration authorization?

12. What is the usage of grant?

13. Define distributed system.

14. List out the different process in transaction server.

15. What is data caching?

part B (6 x five = 30)

ans any 6 ques.

16. Explain any 3 disadvantages of file system.

17. What are the applications of a database system?

18. Write short notes on a) Super Key b) Primary Key

19. Briefly discuss the Domain Relational Calculus.

20. Briefly discuss the basic structure of SQL.

21. Explain packages briefly.

22. What are domain constraints? discuss with suitable examples.

23. When is a relation stated to be in the Boyce-Codd normal form?

24. Briefly define centralized systems.

part C (4 x 10 = 40)

ans any 4 ques.

25. Write short notes on a) Entity b) Entity Set c) Attribute d) Relationship
e) Relationship Set.

26. Explain the operations used in the Modification of Database in Relational Algebra.

27. Explain all the commands under Data Manipulation Language.

28. Explain in detail the embedded and Dynamic SQL

29. What is normalization? discuss in detail.

30. Describe the network kinds in detail

Earning:   Approval pending.