M.C.A. DEGREE EXAMINATION, APRIL/MAY 2018.
Second Semester
Part IV DATABASE MANAGEMENT SYSTEMS
2 90224-AA
Time 3 Hours Max. Marks 70
SECTION — A
Answer any FIVE questions. 6 30 Marks)
1. What are the advantages of DBMS compare to file processing systems? Explain in
detail?
2. What is the need of relational model? Explain with example.
3. What are various data types use in SQL and also describe various DCL commands?
4. Write about nested queries and correlated queries.
5. Explain the relationship between BCNF and Dependency preservation.
6. What is meant by term relationship between entities? Explain about the different
types of relationships that can exist with examples?
7. What is deadlock? Illustrate the same using the Wait-For-Graph.
8. What is a system log? What is the purpose of the system log in system recovery?
SECTION — B
Answer ALL questions. 10 40 Marks)
9. Explain about abstract view of data models in detail.
Or
10. What are integrity constraints? Explain various types of integrity constraints with
suitable example.
11. What are views? How to create views? Discuss the problems encountered in
modifying database through views?
Or
12. Explain domain and tuple relational calculus in detail.

13. Explain overall logical structure of E-R Diagram and also give extended diagram
rules.
Or
14. What is a multivalued dependency? What kind of constraint does it specify?
Explain Closure of Set of Functional dependency and closure of Attribute
sets.
15. What is authorization and authentication? Explain the access controls in a
database.
Or
16. Discuss the concurrency control mechanism in detail using suitable example.
———————