Thursday, February 18, 2016

Anna University CS1301 DBMS Question papers May June 2007

CS1301 Database Management Systems question paper - May-June 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

Time: Three hours                                                              Maximum: 100 Marks
Answer ALL Questions
PART A — (10 × 2 = 20 Marks)
1. List five responsibilities of the DB manager.
2. Give the limitations of ER model? How do you overcome this?
3. Define query language. Give the classification of query language.
4. Why it is necessary to decompose a relation?
5. Give any two advantages of spare index over dense index.
6. Name the different types of joins supported in SQL.
7. What are the types of transparencies that a distributed database must support? Why?
8. What benefit is provided by strict-two phase locking? What is the disadvantages result?
9. Briefly write the overall process of data warehousing.
10. What is an active database?

PART B — (5 × 16 = 80 Marks)

11 (a) (i) What are the types of knowledge discovered during data mining? Explain with suitable examples.
(ii) Highlight the features of object oriented database.
(b) (i) What is nested relation? Give example.
(ii) Explain the structure of XML with suitable example.
12 (a) (i) Compare file system with database system.
(ii) Explain the architecture of DBMS.
(b) (i) What are the steps involved in designing a database application? Explain with an example.
(ii) List the possible types of relations that may exist between two entities. How would you realize that into tables for a binary relation?
13. (a) (i) What are the relational algebra operations supported in SQL? Write the SQL statement for each operation.
(ii) Justify the need of normalization with examples
(b) (i) What is normalization? Explain 1NF, 2NF, 3NF and BCNF with suitable example.
(ii) What is FD? Explain the role of FD in the process of normalization.
14. (a) (i) Explain the security features provided in commercial query languages.
(ii) What are the steps involved in query processing? How would you estimate the cost of the query?
(b) (i) Explain the different properties of indexes in detail.
(ii) Explain various hashing techniques.
15. (a) (i) Explain the four important properties of transaction that a DBMS must ensure to maintain database .
(ii) What is RAID? List the different levels in RAID technology and explain its features.
(b) (i) What is Concurrency control? How is it implemented in DBMS? Explain.
(ii) Explain various recovery techniques during transaction in detail.


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