STUPIDSID
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
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
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
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