CS2255 Database Management Systems question paper - Nov/Dec 2012 / Anna University Previous Year 2012 Exam Questions / Anna University Previous Year 2012 Computer Science and Information Technology Question Papers
Question Paper
Code : 11275
B.E./B.Tech.
DEGREE EXAMINATION, NOVEMBER/DECEMBER 2012
Fourth
Semester
Computer
Science and Engineering
CS
2255/141405/CS 46/CS 1254/10144 CS 406/080250009 — DATABASE MANAGEMENT SYSTEMS
(Common
to Information Technology)
(Regulation
2008)
(Common
to PTCS 2255 – Database Management Systems for B.E. (Part-Time) for Third
Semester – Computer Science and Engineering (Regulation 2009))
Time
: Three Hours Maximum
: 100 marks
Answer
ALL Questions
PART
A – (10 X 2 = 20 marks)
1. Distinguish the
terms primary key and super key.
2. Specify the
difference between physical and logical data independence.
3. Mention the six
fundamental operations of relational algebra and their symbols.
4. List two reasons
why null values might be introduced into the database.
5. Define Multivalued
dependency.
6. Show that, if a
relational database is in BCNF, then it is also in 3NF.
7. Write down the SQL
facilities for recovery.
8. State the
write-ahead log rule. Why is the rule necessary?
9. What can be done
to reduce the occurrence of bucket overflows in a hash file organization?
10. How might the
type of index available influence the choice of a query processing strategy?
PART
B – (5 X 16 = 80 marks)
11. (a) (i) Discuss
in detail about the major disadvantages of file-processing system.(6)
(ii) Explain in
detail about different data models with neat diagram.(10)
Or
(b) Draw an E-R
diagram for a Life insurance company with almost all components and explain.(16)
12. (a) Give an
introduction to Distributed Database and Client/Server database.(16)
Or
(b) Illustrate the
uses of Embedded SQL and Dynamic SQL with suitable examples.(16)
13. (a) Explain in
detail about all functional dependencies based normal forms with suitable
examples.(16)
Or
(b) Describe about
the Join Dependencies and Fifth normal form with suitable example.(16)
14. (a) Discuss in
detail about transaction concepts and two phase commit protocol.(16)
Or
(b) Write down in
detail about intent locking and isolation levels.(16)
15. (a) Jot down
detailed notes on ordered indices and B-Tree index files.(16)
Or
(b) Describe in
detail about RAID and Tertiary storage.(16)
________________________