Mca312- Advanced Database Management System.pdf

ASSIGNMENT DRIVE PROGRAM SEMESTER SUBJECT CODE & NAME BK ID NUMBER OF ASSIGNMNETS, CREDITS & MARKS

FALL 2018 MCA 3 MCA312- ADVANCED DATABASE MANAGEMENT SYSTEM B1649 2, 4 Credits, 30 marks each

Note –The Assignment is divided into 2 sets. You have to answer all questions in both sets. Average of both assignments score scored by you will be considered as your IA score. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.

Q.No 1 2 3

Q.No 1 2 3

Assignment Set -1 Questions Differentiate between Two-Tier client/server databases and Multi-tier client/server databases. Explain the physical query plan operators. What is the significance of Iterators? Differentiate between Serialisability and Recoverability.

Assignment Set -2 Questions Discuss about Parallel query processing. How parallelexecution works? Differentiate between homogeneous and heterogeneous Database. Write short notes on ODMG standards. What are the various components of ODMG-93?

Marks

Total Marks

5+5

10

6+4

10

10

10

Marks

Total Marks

4+6

10

10

10

5+5

10