JNTUA MCA 3rd Sem last 10 year 2010-2020 Previous Question Papers (JNTU Anantapur)
Code: 9F00301
MCA II Semester Supplementary Examinations July 2015
--- Content provided by FirstRanker.com ---
DATABASE MANAGEMENT SYSTEMS
(For students admitted in 2009, 2010, 2011, 2012 and 2013 only)
Time: 3 hours Max Marks: 60
Answer any FIVE questions
All questions carry equal marks
--- Content provided by FirstRanker.com ---
- Explain the importance of database design.
- Write the differences between file system and database management system.
- Draw and explain E-R diagram of an airline reservation system.
- What is E-R model? Explain in detail.
- What is a relationship? Explain different types of relationship in detail.
- What is a key? Describe different types of keys used in database.
- Explain different types of joins with suitable examples.
- What are relational set operators? Explain with examples.
- What are the advantages of normalization?
- Explain denormalization with example.
- Explain the concept of transaction atomicity.
- Explain concurrency control with locking methods.
- What is recovery? Also explain log based recovery.
- Explain remote backup system in DBMS.
- Briefly describe ISAM.
- Compare the ordered indexing with hashing.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
This download link is referred from the post: JNTUA MCA 3rd Sem last 10 year 2010-2020 Previous Question Papers (JNTU Anantapur)