Total No. of Questions 18] [Total No. of Pages 02
M.Sc. DEGREE EXAMINATION, MAY 2017
First Year
COMPUTER SCIENCE
Database Management Systems
Time 3 Hours Maximum Marks 70
SECTION A
Answer any three Questions × 15 45)
Q1)Explain the following with their advantages and disadvantages.
Hierarchical database model
ii) Network database model
iii) Relational database model.
Q2) What is Relational Algebra? Enlist and explain the fundamental operation of
relational algebra with suitable example.
Q3) Discuss aggregate functions and nested queries in SQL with syntax.
Q4) Explain about structures of magnetic disks and RAID levels.
Q5) Explain various deadlock prevention methods.
Write about the view serializability with example.
SECTION B
Answer Any Five questions (5×4 20)
Q6) Explain in detail the duties of DBA.
Q7) Draw symbols for following in ER diagram.
Q8) Explain Database Triggers.
Q9) What is functional dependency? Explain its usage in database design. .
Q10) Write about static and dynamic hashing.
Q11) What is a transaction? Explain its four important properties.
Q12) Explain 1NF, 2NF and 3NF with example.
Q13) Briefly explain about time stamp based protocols.
SECTION C
Answer All Questions ×1
Q14) Define primary key.
Q15) Define instance and schema.
Q16) Define atomicity.
Q17) What are the DCL commands?
Q18) What are the Correlated Queries?