Firstranker's choice
--- Content provided by FirstRanker.com ---
Code: 9F00301
MCA II Semester Regular & Supplementary Examinations November/December 2017
DATABASE MANAGEMENT SYSTEMS
(For 2012, 2013, 2014, 2015 & 2016 admitted batches only)
Time: 3 hours Max. Marks: 60
--- Content provided by FirstRanker.com ---
Answer any FIVE questions
All questions carry equal marks
- How does a database management system overcome the disadvantages of a file system?
- What is a data model? Why is it important? Explain various types of data models.
- What is a weak entity set? How is it handled in an ER diagram?
- Construct an ER diagram for an online train reservation system such as irctc.co.in.
- With examples, explain left outer join & theta join.
- What is the content of a system catalog? Why is it important?
- Describe the relational database rules proposed by Dr. E.F. Codd.
- Consider the following database schema to write queries in SQL.
--- Content provided by FirstRanker.com ---
Sailor (Sid, Sname, age, rating)
Boats (bid, bname, bcolor)
Reserves (Sid, bid, day)
(i) Find the names of sailors who have reserved at least two boats.
(ii) Find the boats which do not have reservations.--- Content provided by FirstRanker.com ---
(iii) List the colors of the boats reserved by “Raman”. - Explain the need for normalization with suitable example scenarios. Discuss the concepts of partial dependency and transitive dependency.
- Quote an example relation which is in 3NF but not in BCNF.
- What is a transaction? Explain the desirable properties of a transaction.
- How to test serializability? Discuss with examples. Does two-phase locking ensure serializability?
- What is a log? What is a log tail? Explain its use in recovery.
- Describe the significance of pincount and dirty bit in buffer management.
- With a necessary diagram, explain magnetic disk organization.
- Differentiate between B tree and B+ tree indices.
--- 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)
--- Content provided by FirstRanker.com ---