0
661views
Database Management Systems Question Paper - Dec 17 - Information Technology (Semester 3) - Mumbai University (MU)
1 Answer
0
0views

Database Management Systems - Dec 17

Information Technology (Semester 3)

Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.

1.a. Identify and list down file operations.
(5 marks) 00

1.b. Describe ACID properties.
(5 marks) 00

1.c. Explain total participation and partial participation with example.
(5 marks) 00

1.d. Explain aggregate function with example.
(5 marks) 00

2.a. Explain stored procedure and functions with example.
(10 marks) 00

2.b. Explain shadow paging.
(10 marks) 00

3.a. Identify and list all functional dependencies satisfied by the relation.

X Y Z
1 4 2
1 5 3
1 6 3
3 2 2

(10 marks) 00

3.b. Explain ER model into relational model conversion with example.
(10 marks) 00

4.a. Describe view in SQL with example.
(10 marks) 00

4.b. Explain any 2 concurrency protocols in database systems.
(10 marks) 00

5.a. List various types of constraints in database? Explain any two.
(10 marks) 00

5.b. Explain cost based query optimization.
(10 marks) 00

6.a. Explain deadlock with wait-for-graph.
(10 marks) 00

6.b. Explain conflict and view serializabilty with example.
(10 marks) 00

Please log in to add an answer.