Wednesday, February 8, 2023

Dr. A.P.J. Abdul Kalam University MTECH II SEM (CSE) Advance Database Management System [MTCSE203] June 2021 Question Paper

Dr. A.P.J. Abdul Kalam University

Master of Technology

Second Semester Examination, June-2021

Advance Database Management System [MTCSE203]

Time: 3:00 Hrs. Max Marks 70

Note : (i) Attempt any five questions out of eight.

(ii) All question carry equal marks.

Q.1 Discuss the main characteristics of the database approach and how it differs

from traditional file system.

Q.2 What do you understand by distributed databases? Give the various

advantages and disadvantages of distributed database management systems.

Q.3 How data mining system can be integrated with data warehouse system?

What is logical data independence and why is it important?

Q.4 What do you understand by timestamp based protocol? Discuss multiversion scheme also.

Q.5 Differentiate among candidate key, primary key, super key and foreign key.

Q.6 Describe the overall structure of a general database management system.

Q.7 What do you mean by data abstraction, views data model, DDL, DML.

Discuss all its types.

Q.8 Define the following terms: entity, attribute, relationship type, attribute type,

relationship set.

Scanned Copies:



Search Everything Here