Get premium membership and access revision papers, questions with answers as well as video lessons.
Database Management System Question Paper
Database Management System
Course:Diploma In Information Communication Technology Module Ii
Institution: Masai Technical Training Institute question papers
Exam Year:2014
MASAI TECHNICAL TRAINING INSTITUTE
DIPLOMA
MODULE II
DBMS
2013 Term II – 19th June, 2016.
2hours
Note: 1. Question Paper consists of two parts (Part-A and Part-B)
2. Answering the question in Part-A is compulsory
3. Answer any THREE Questions from Part-B
*****
PART –A
1 a) List out Data base applications. [3M]
b) Write the syntax for UPDATE command in SQL. [3M]
c) Write short notes on nested queries. [4M]
d) What is an objective of the normalization? [4M]
e) Explain about deadlocks. [4M]
f) Explain about hash based indexing. [4M]
PART –B
2 a) Explain in detail about Database Management System advantages over file
management system.
[6M]
b) Explain the architecture of DBMS. [6M]
c) Explain the concept of Data independence.
[4M]
3 a) Explain the following:
i) Key constraints ii) Integrity constraints.
[10M]
b) Differentiate between where clause and group by clause. [3M]
c) Explain the different data types in SQL.
[3M]
4 a) Consider the following schemas:
Sailors (sid, sname, rating, age)
Reserves (sid, bid, day)
Boats (bid, bname, color)
Write the following queries in relational algebra, tuple relational Calculus and
domain relational calculus:
a) Find the name of sailors who have reserved boat 103.
b) Find the names and ages of sailors with a rating above 7.
c) Find the names of sailors who have reserved a red boat.
d) Find the sname, bid, and day for each reservation.
e) Find the name of sailors who have reserved at least one boat.
[10M]
b) Draw an ER diagram for Hospital management system.
1 of 2
[6M]
5 a) Explain briefly about 3NF, 4NF and BCNF with suitable examples? [8M]
b) What is Functional Dependency? Explain types and properties of FD’s.
[8M]
6 a) Explain the time stamp based protocol for concurrency control in a DBMS. [8M]
b) Explain the ARIES recovery method. When does a system recover from a
crash? In what order must a transaction be undone and redone? Why is this
order important?
[8M]
7 a) Distinguish between:
i) Primary and Secondary indexing. ii) Ordered indexing and hashing.
[8M]
b) Explain in detail about B+ trees. [8M]
More Question Papers
Popular Exams
Return to Question Papers