Advanced Database Management System - Tutorials and Notes: Anna University CS1301 DBMS Question papers November December 2007

Thursday, 18 February 2016

Anna University CS1301 DBMS Question papers November December 2007

CS1301 Database Management Systems question paper - Nov-Dec 2007 / Anna University Previous Year Exam Questions / Anna University Previous Year Computer Science and Information Technology Question Papers / Anna University Previous Year CS1301 DBMS Exam Questions under Regulation 2004

Fifth Semester
Computer Science and Engineering
 (Regulation 2004)
Time: Three hours                                                              Maximum: 100 Marks
Answer ALL Questions
PART A — (10 × 2 = 20 Marks)
1. List any two advantages of database systems.
2. Give the reasons why null values might be introduces into the database.
3. What is static SQL? How does it differ from dynamic SQL?
4. What are the different types of integrity constraints used in designing a relational database?
5. Compare sequential access devices versus random access devices with an example.
6. What can be done to reduce the occurrences of bucket overflows in a hash file organization?
7. Give the ACID properties.
8. State the benefits of strict two-phase locking.
9. What is the need for complex data types?
10. What is data mining?

PART B — (5 × 16 = 80 Marks)

11. (a) Explain the system structure of a database system with neat block diagram. (16)
(b) (i) Construct an ER-diagram for hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. (8)
(ii) Discuss on various relational algebra operators with suitable Example. (8)
12. (a) (i) Consider the employee database, where the primary keys are underlined.
Employee (empname, street, city)
Works (empname, companyname, salary)
Company (companyname, city)
Manages (empname, managername)
And give an expression in SQL for the following queries:
(1) Find the names of all employees who work for First Bank Corporation.
(2) Find the names, street addresses, and cities of residence of all employees who work for First Bank Corporation and earn more than 200000 per annum.
(3) Find the names of all employees in this database who live in the same city as the companies for which they work.
(4) Find the names of all the employees who earn more than every employees of Small Bank Corporation. (4 * 2 = 8)
(ii) Discuss the strengths and weaknesses of the trigger mechanism. Compare triggers with other integrity (8)
(b) (i) What is normalization? Explain the various normalization techniques with suitable example. (12)
(ii) Give the comparison between BCNF and 3NF. (4)
13. (a) (i) Explain how the RAID system improves performance and reliability. (8)
(ii) Describe the structure of B+ tree and list the characteristics of a B+ tree. (8)
(b) (i) Explain the steps involved in processing a query. (8)
(ii) Give the algorithm for hash join. (8)
14. (a) (i) Describe about the testing of serializability. (6)
(ii) Discuss on two-phase locking protocol. (10)
(b) (i) Explain the differed and immediate-modification versions of the log-based recovery scheme (10)
(ii) Write the short notes on shadow paging (6)
15 (a) (i) Highlight the features of OODBMS (8)
(ii) Write short notes on distributed databases (8)
(b) (i) Give the structure of XML data. (4)
(ii) Explain the architecture of a typical data warehouse and describe the various components of data warehouse. (12)


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