Wednesday, March 2, 2016

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

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)

(ii) Explain about Discretionary access Control Based on Granting and Revoking Privileges. (8)
Or
(b) Write Short notes on: (16)
(i) Classification
(ii) Clustering.


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









No comments:

Post a Comment

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