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:

Shiva

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!