Dr. A.P.J. Abdul Kalam University MTECH I SEM (CTA) Advanced Database Management System (MTCTA-104) Dec 2020 Question Paper

Dr. A.P.J. Abdul Kalam University

Master of Technology

First Semester Main Examination, Dec-2020

Advanced Database Management System (MTCTA-104)

Time: 3:00 Hrs Max Marks 70

Note : Attempt any five questions out of eight.

All question carry equal marks.

Q.1 (a) Discuss different type of database management system with advantages and

disadvantages.

(b)Why the normalization process is necessary for a good database design?

Q.2 (a) What are the different techniques for database recovery? Discuss in details.

(b) What are different types of relational query languages?

Q.3 (a) Discuss in detail concurrency control in case of distributed database

management systems.

(b) What are the different advantages of a distributed database management

system?

Q.4 (a) Write short notes on deductive database.

(b) What is the use of data warehouse?

Q.5 (a) Difference between relational and object relational database.

(b) Explain need for object database.

Q.6 (a) Explain data loading and its types.

(b) What is the objective of data mining?

Q.7 (a) What is the use of online analytical processing?

(b) Explain with suitable example ‘Star Schema’

Q.8 Write short notes on -

(a) Spatial Database.

(b) Mobile Database. 

Scanned Copies:

Share This