1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
M.C.A.DEGREE EXAMINATION COMPUTER APPLICATIONS
FIRSTSEMESTER APRIL 2018
CA 1808- DATABASE MANAGEMENT SYSTEMS
Date: 30-04-2018 Dept. No. Max. 100 Marks
Time: 09:00-12:00
PART A
Answer ALL questions 10 X 2 20
1. Define DBMS.
2. What are various forms of authorization?
3. List few parts of UML.
4. Define 1NF.
5. Write the syntax of creating roles in sql.
6. Define data dictionary.
7. Give few types of file indices.
8. Define query optimization.
9. What is concurrent execution? Why is it needed?
10. Why buffer need to be maintained in data recovery?
PART B
Answer ALL questions 5 X 8 40
11. Elucidate on disadvantages of file system.
Or
Write and explain the aggregate functions of sql.
12. Explain the basic notion of ER with an example.
Or
What are multivalued dependencies? Explain 4NF with example.
13. Define Triggers. Explain its features and need.
Or
Write note on various RAID levels.
14. What is dynamic hashing? Explain its features.
Or
Describe the choices of evaluation plan.
15. Write note on lock based protocol of transaction.
Or
Describe data recovery with concurrent transaction.
2
PART C
Answer any TWO questions 2 X 20 =40
16. With necessary diagram explain database architecture.
Discuss on BCNF with example. How it differs from 3NF?
17. Explain the overview of physical storage media.
Discuss on various equivalence rule.
18. Explain time stamp based protocol of transaction.
"Microsoft SQL is one of the effective DBMS language"- Justify.