MC 1654 – Database Management Systems - May June 2008 Question Paper / Anna University MCA Exam May June 2008 Question Paper / MC1654 DBMS May June 2008 Question Paper / MC1654 Database Management Systems Previous Year MCA Question Paper / Anna University Affiliated Colleges MCA Question Papers / MC1654 DBMS Regulation 2005 MCA Question Paper / MCA Second Semester Question Paper
Question
Paper Code :
M.C.A
DEGREE EXAMINATION, MAY/JUNE 2008
MC
1654 – DATABASE MANAGEMENT SYSTEMS
(Regulation
2005)
Time
: Three Hours Maximum
: 100 marks
Answer
ALL Questions
PART
A – (10 X 2 = 20 marks)
1.
Write any four major disadvantages of keeping organization information in a
file processing system.
2.
Define a weak and strong entity set.
3.
What is a condition Box in the context of Query By example (QBE)?
4.
Write the advantages and Disadvantages of 3 NF.
5.
Difference between mirroring and striping.
6.
What are Bitmap indices?
7.
How can you measure the cost of a query?
8.
List some of the useful statistical information about database relations as
maintained by DBMS catalog.
9.
Write any four properties of a transaction.
10.
What is fuzzy check point?
PART
B – (5 X 16 = 80 marks)
11.
(a) (i) Explain two methods for dealing with the deadlock problem ?
(ii)
Write short note on shadow paging and buffer management.
Or
(b)
(i) Explain the distinction between the terms Serial Schedules and Serializable
Schedules.
(ii)
During its execution, a transaction passes through several stages, until it
finally commits or aborts. List all possible sequences of stages through which
a transaction may pass.
12.
(a) Explain various data models with suitable examples for each.
Or
(b)
(i) Construct an E-R diagram with all major components for a banking
enterprises with entity set customer, branch, loan, payment, account, employee
with other own assumption.
(ii)
Write short note on history of database system
13.
(a) (i) Explain the fourth Normal Form (4NF).
(ii)
Write short note on Embedded SQL.
Or
(b)
(i) Explain about Functional Dependencies (FD’s).
ii)
Write short note on Embedded SQL.
14.
(a) (i) Explain the physical characteristics of Disk.
(ii)
What is RAID? Explain all the RAID levels.
Or
(b)
Explain B+ Tree index files.
15.
(a) What do you mean by external sorting? Explain the merge sort technique and
discuss its performance.
Or
(b)
How can you perform heuristic optimization? Explain the various heuristics in
query optimization with examples
*************