SPPU Information Technology (Semester 5)
Database Management Systems
December 2014
Total marks: --
Total time: --
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary

Answer any one question from Q1 and Q2
1 (a) Explain good database design properties. With suitable example explain the consequences of bad designing.
5 M
1 (b) Explain with suitable example SQL aggregate functions.
5 M

2 (a) Define serializable schedule. Explain two forms of serializability.
5 M
2 (b) What is a relation? What are the properties of relation? Explain with example.
5 M

Answer any one question from Q3 and Q4
3 (a) Explain the following extended entity relationship features of E-R model.
i) specialization
ii) generalization
iii) aggregation
iv) attribute inheritance
5 M
3 (b) Explain rigorous two phase locking protocol.
5 M

4 (a) What is a deadlock? Explain deadlock recovery techniques.
4 M
4 (b) Write the syntax for following SQL commands:
i) create table
ii) alter table
iii) drop table
iv) insert
v) delete
vi) update
6 M

Answer any one question from Q5 and Q6
5 (a) Explain characteristics and advantages of distribution systems.
8 M
5 (b) Detail the procedure for connectivity of MongoDB with java.
8 M

6 (a) Explain the need of data fragmentation and types of fragmentation.
8 M
6 (b) Explain the speed-up and scale up issues with respect to parallelism.
8 M

Answer any one question from Q7 and Q8
7 (a) Draw and explain basic building blocks of Hadoop.
8 M
7 (b) Describe XML data model. List the advantages of XML.
8 M

8 (a) Explain various components of Hadoop.
8 M
8 (b) Write a short note on:
i) Xquery ii) JSON
8 M

Answer any one question from Q9 and Q10
9 (a) Draw and explain main components of data warehouse and its characteristics.
9 M
9 (b) What are the characteristics of NoSQL cloud database?
9 M

10 (a) What are the requirements of mobile database? List existing mobile database.
9 M
10 (b) What is a decision support system? Explain storage and data retrieval issues related to it.
9 M

More question papers from Database Management Systems