CS6302 DBMS April May 2018 Regulation 2013 Anna University Questions with Answers

Anna University Questions with Answers - CS6302 Database Management Systems April May 2017, Computer Science and Engineering, Information Technology Questions, Third semester, fifth, and eighth semester, Regulation 2013

CS6302 Database Management Systems for B.E. Computer Science and Engineering

CS6302 Database Management Systems for B.Tech. Information Technology

CS6302 Database Management Systems for B.E. Mechanical and Automation Engineering

Exam	B.E/B.Tech. (Full Time) DEGREE END SEMESTER EXAMINATIONS
Academic Year	April May 2018
Subject Code	CS6302
Subject Name	Database Management Systems
Branch	Computer Science and Engineering
Semester	Third / Fifth / Eighth Semester
Regulation	2013

 

Question Paper Code : 40901

B.E./B.Tech. DEGREE EXAMINATION, APRIL/MAY 2018

Third/Fifth/Eighth Semester

Computer Science and Engineering

CS 6302 — DATABASE MANAGEMENT SYSTEMS

(Common to Mechanical and Automation Engineering, Mechatronics Engineering, Information Technology)

(Regulation 2013)

 

 

Time : Three hours                                                             Maximum : 100 marks

 

Answer ALL questions.

PART A — (10 × 2 = 20 marks)

 

1. What is weak entity? Give example.

2. Define a foreign key. Give example.

3. What is data definition language? Give example.

4. Outline the steps involved in query processing.

5. What is serializability?

6. State the difference between a shared lock and an exclusive lock.

7. What is hash function? Give example.

8. Define data mining.

9. What is a distributed database management system?

10. State the difference between classification and clustering.

 

PART B — (5 × 13 = 65 marks)

 

11. (a) Explain select, project, Cartesian product, and join operations in relational algebra with an example.

 

OR

(b) What is database normalization? Explain first normal form, second normal form, and third normal form with an example.

 

12. (a) Explain the aggregate functions in SQL with example.

OR

(b) What is query optimization? Outline the steps in query optimization.

 

13. (a) i) During execution, a transaction passes through several states, until it finally commits or aborts. List all possible sequences of states through which a transaction may pass. Explain why each state transition may occur? (6)

ii) Explain with an example the properties that must be satisfied by a transaction. (7)

OR

(b) i) What is concurrency control? Explain the two-phase locking protocol with an example. (7)

ii) Explain conflict serializability and view serializability. (6)

 

14. (a) What is hashing? Explain static hashing and dynamic hashing with an example.

OR

(b) Outline the features of the following databases:

i) Parallel databases (7)

ii) Multimedia databases (6)

 

15. (a) i) Present an overview of database security. (8)

ii) Explain with diagrammatic illustration the architecture of a distributed database management system. (5)

OR

(b) Explain the necessary characteristics a system must satisfy to be considered as an object oriented database management system.

PART C is skipped here.

*****************************

Go to Anna University DBMS Exam Questions page.

Go to Previous year University Exam Questions page.

 

CS6302 DBMS December 2017 Regulation 2013 Anna University Questions with Answers

Anna University Questions with Answers - CS6302 Database Management Systems April May 2017, Computer Science and Engineering, Information Technology Questions, Third semester, fifth, and eighth semester, Regulation 2013

CS6302 Database Management Systems for B.E. Computer Science and Engineering

CS6302 Database Management Systems for B.Tech. Information Technology

CS6302 Database Management Systems for B.E. Mechanical and Automation Engineering

Exam	B.E/B.Tech. (Full Time) DEGREE END SEMESTER EXAMINATIONS
Academic Year	November December 2017
Subject Code	CS6302
Subject Name	Database Management Systems
Branch	Computer Science and Engineering
Semester	Third / Fifth / Eighth Semester
Regulation	2013

Question Paper Code : 50383

B.E./B.Tech. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2017

Third/Fifth/Eighth Semester

Computer Science and Engineering

CS 6302 — DATABASE MANAGEMENT SYSTEMS

(Common to Mechanical and Automation Engineering, Mechatronics Engineering, Information Technology)

(Regulation 2013)

 

 

Time : Three hours                                                             Maximum : 100 marks

 

Answer ALL questions.

PART A — (10 × 2 = 20 marks)

 

1. State the levels of abstraction in DBMS.

2. What are the problems caused by redundancy?

3. What is static SQL and how is it different from dynamic SQL?

4. State the steps in query processing.

5. State need for concurrency.

6. Define ACID properties.

7. What are data fragmentations? State the various fragmentations with example.

8. Define ordered indices with example.

9. Distinguish between threats and risks.

10. State the function of XML schema.

 

PART B — (5 × 13 = 65 marks)

 

11. (a) i) Differentiate between foreign key constraints and referential integrity constraints with suitable example. (6)

ii) Distinguish between lossless-join decomposition and dependency preserving decomposition. (7)

OR

(b) State and explain the architecture of DBMS. Draw the ER diagram for banking systems.

 

12. (a) i) State and explain the command DDL, DML, DCL with suitable example. (7)

ii) Justify the need of embedded SQL. Consider the relation student(studentno, name, mark, grade). Write embedded dynamic SQL statements in C language to retrieve all the students’ records whose mark is more than 90. (6)

OR

(b) Explain the catalog information for cost estimation for selection and sorting operation in database.

 

13. (a) State and explain the lock based concurrency control with suitable example.

OR

(b) When does deadlock occur? Explain two-phase commit protocol with example.

 

14. (a) i) What are the various features of distributed database versus centralized database system? (6)

ii) Explain the B+ tree indexes on multiple keys with a suitable example. (7)

OR

(b) Explain the distinction between static and dynamic hashing. Discuss the relative merits of each technique in database applications.

 

15. (a) i) Distinguish between classification and clustering with example. (6)

ii) State the necessity for crawling and indexing the web. Explain the procedure for it. (7)

OR

(b) Describe the various component of data warehouse and explain the different data model used to store data with example.

PART C — (1 × 15 = 15 marks)

 

16. (a) Explain in detail about spatial and multimedia databases.

OR

(b) Write the DDL, DML, DCL commands for the students database which contains student details: name, id, DOB, branch, DOJ. Course details: course name, stud id, faculty name, id, marks.

 

*****************************

Go to Anna University DBMS Exam Questions page.

Go to Previous year University Exam Questions page.