Code No: 813AP R13
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
--- Content provided by FirstRanker.com ---
MCA 111 Semester Examinations, June/July - 2018
DATABASE MANAGEMENT SYSTEMS
Time: 3 Hours Max. Marks: 60
Note: This question paper contains two parts A and B.
--- Content provided by FirstRanker.com ---
Part A is compulsory which carries 20 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 8 marks and may have a, b, c as sub questions.
PART - A 5 x 4 Marks =20
- For what reasons database management system is preferred over file system? [4]
- What is the use of outer join? Give its types. [4]
- Define multi valued dependency. [4]
- Suggest any one mechanism for media recovery. [4]
- Define track, sector, cylinder of disk. [4]
--- Content provided by FirstRanker.com ---
PART -B 5 x 8 Marks = 40
- How does database management system provide data abstraction? Explain with illustrations. [8]
OR--- Content provided by FirstRanker.com ---
Construct an ER diagram to design a database for online movie ticket booking application such as firstranker.com. [8] - Consider the following database schema to write queries in Relational Algebra.
Student-(:Sid, Sname, total credits)
Course('Cno, Ctitle, Number of credits)
Enroll(Sid, Cno, Grade)--- Content provided by FirstRanker.com ---
(a) Find the students’ names who secured “A” grade in DBMS course.
(b) Find the titles of the courses which do not have enrollment of any student. [4+4]
OR
What is an assertion? How to define assertion in SQL? Explain with suitable example.[8] - Describe the need of schema refinement. What is the effect on database if this phase is skipped by the designers? [8]
--- Content provided by FirstRanker.com ---
OR
How to compute the attribute closure?
What is meant by partially functional dependent? [4+4] - What is a transaction? What is a schedule? What is meant by serializability? Quote examples for all these. [8]
OR--- Content provided by FirstRanker.com ---
List the different types of failures and explain log based recovery for concurrent transactions. [8] - Make a comparison of the three file organizations- heap, sorted, hash. [8]
OR
Demonstrate bulk loading of B+ tree. Consider suitable student data records and construct B+ tree structure. [8]
--- Content provided by FirstRanker.com ---
This download link is referred from the post: JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university
--- Content provided by FirstRanker.com ---