CS6302 Database Management Systems November December 2014

Anna University Questions with Answers - CS6302 Database Management Systems November December 2014, Computer Science and Engineering, Information Technology Questions, Third semester, Regulation 2013

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

B.E / B.Tech. (Full Time) DEGREE END SEMESTER EXAMINATIONS, NOVEMBER / DECEMBER 2014

Computer Science and Engineering

Third Semester

CS6302 – DATABASE MANAGEMENT SYSTEMS

(Common to Computer and Communication Engineering and Information Technology)

(Regulations 2013)

Time : 3 Hours                      Answer A L L Questions                Max. Marks 100

PART-A (10 x 2 = 20 Marks)

1. Why 4NF in normal form is more desirable than BCNF?

2. What is the purpose of Database Management System?

3. Differentiate between Dynamic SQL and Static SQL.

4. Give a brief description on DCL command.

5. Define the properties of Transaction.

6. What is Serializability? How it is tested?

7. Differentiate between Static and Dynamic Hashing.

8. Define Data Mining and Data Warehousing.

9. What is Crawling and Indexing the web?

10. What is Relevance Ranking?

Part-B (5* 16 = 80 Marks)

11. (a) Write Short Notes on; (16)

(i) Data Model and its Types.

(ii) E-R. Diagram for Banking System.

Or

(b) What are Normal forms. Explain thetypes of Normal form with an example. (16)

12. (a) Explain the following with examples:

(i) DDL  (4)

(ii) DML (4)

(iii) Embedded SQL  (8)

Or

(b) Give a detailed description aboutQuery Processing and Optimization. Explain the cost estimation of Query Optimization. (16)

13. (a) What is Concurrency? Explain it in terms of locking mechanism and two phase Commit Protocol.  (16)

Or

(b) Write short notes on: Q.

(i) Transaction concept. (8)

(ii) Deadlock. (8)

14. (a) (i) Explain in detail RAID technology. (8)

(ii) Write short notes on Spatial and Mobile Databases. (8)

Or

(b) Explain in detail about (i) B+ tree index (ii) B tree index Files. (16)

15. (a) (i) Write short notes onDistributed Transactions. (8)

(ii) Explain about Discretionary access Control Based on Granting and Revoking Privileges. (8)

Or

(b) Write Short notes on: (16)

(i) Classification

(ii) Clustering.

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

 Go back to Anna University DBMS Exam Questions page.