Saturday, May 17, 2014

CS2255 Database Management Systems question paper - Nov/Dec 2012

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
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)
(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)
(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)
(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)
(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)
(b) Describe in detail about RAID and Tertiary storage.(16)



Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery