1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
M.C.A.DEGREE EXAMINATION COMPUTER APPLICATIONS
FIRSTSEMESTER APRIL 2018
17/16PCA1MC05- DATABASE MANAGEMENT SYSTEMS
Date: 02-05-2018 Dept. No. Max. 100 Marks
Time: 09:00-12:00
PART A
Answer ALL questions 10 X 2 20
1. List the levels of abstraction.
2. What are integrity constrains? List some of them.
3. What is generalization?
4. Define temporal data.
5. How users interact with databases?
6. List the ways of organizing records in files.
7. Give the reasons for overflow of buckets in data storage.
8. What is query processing?
9. List the states of transaction.
10. What are transaction check points?
PART B
Answer ALL questions 5 X 8 40
11. Write note on Database languages.
Or
Describe built-in data types and schemas of sql.
12. Explain the basic representation of ER model.
Or
Write note on 3NF with its features.
13. Describe the fundamental techniques used on World Wide Web.
Or
Discuss on various levels of RAID.
14. Elucidate on indexing of files with example.
Or
Write notes on materialized view with example.
15. Illustrate serializability in transaction execution.
Or
Write notes on advanced recovery techniques.
2
PART C
Answer any TWO questions 2 X 20 =40
16. Write note on DML statements with syntax and example.
Construct an ER model for banking enterprise.
17. Discuss on the security of application with sql authorization.
Explain various rationalities of selection operations.
18. Write note on deadlock handling in database access.
Oracle is an effective database management language Justify.