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

Download JNTUA (JNTU Anantapur) MCA (Master of Computer Applications) 2014 Sept-Oct Supplementary 3rd Sem 06MC301 Database Management Systems Question Paper

www.FirstRanker.com
Code: 06MC301
MCA III Semester Supplementary Examinations September/October 2014
DATABASE MANAGEMENT SYSTEMS
(For students admitted in 2008 only)
Time: 3 hours Max Marks: 60
Answer any FIVE questions
All questions carry equal marks
*****

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

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.

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.
(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).
www.FirstRanker.com www.FirstRanker.com
www.FirstRanker.com
FirstRanker.com - FirstRanker's Choice