Download JNTUA MCA 2014 Oct Supply 3rd Sem 06MC301 Database Management Systems Question Paper

B
4
FirstRanker.com

--- Content provided by‍ FirstRanker.com ---

Code: 06MC301

MCA II Semester Supplementary Examinations September/October 2014

DATABASE MANAGEMENT SYSTEMS

(For students admitted in 2008 only)

--- Content provided by​ FirstRanker.com ---

Time: 3 hours Max Marks: 60

Answer any FIVE questions

All questions carry equal marks

1. (a) Explain briefly about database management systems. Differentiate database management system to the file system.
   (b) Explain ER design attributes, entity sets and their relationships.

--- Content provided by​ FirstRanker.com ---

2. (a) Discuss about integrity constraints.
   (b) Explain about views and its advantages.
   (c) Explain briefly about domain relational calculus.
3. (a) What are the aggregate and comparison operators available in SQL? Explain their operation with example queries.
   (b) Explain about complex integrity constraints in SQL triggers.

--- Content provided by‌ FirstRanker.com ---

4. (a) What is normalization? What is the use of normalization in database design?
   (b) Write short notes on: (i) 2NF. (ii) 3NF. (iii) BCNF.
5. (a) Explain ACID properties of a transaction.
   (b) Explain about view scheduling.
6. (a) Explain about different types of locks.
   

   --- Content provided by​ FirstRanker.com ---

   (b) Explain about dead locks.
7. (a) Explain about different indexing techniques.
   (b) Explain about hash based indexing.
8. Explain about Indexed sequential access methods (ISAM).

FirstRanker.com

--- Content provided by‌ FirstRanker.com ---