Tuesday, February 7, 2023

Dr. A.P.J. Abdul Kalam University MCA II Sem Data Base Management System [MCA201] June 2021 Question Paper

Dr. A.P.J. Abdul Kalam University

Master of Computer Application

Second Semester Main Examination, June-2021

Data Base Management System [MCA201]

Time: 3:00 Hrs _______ Max Marks 70

Note: Answer any five questions. All questions carry equal marks.

Q.1 (a) Discuss the main characteristics of the database approach and how it

differs from traditional file system?

(b) What do you understand by distributed databases? Give the various

advantages and disadvantages of distributed database management systems.

Q.2 (a) Differentiate among candidate key, primary key, super key and foreign


(b) Describe the overall structure of a general database management system.

Q.3 (a) What is normalization? Why is it needed? Discuss all the normal forms in


(b) What is the difference between 3 NF & BCNF?

Q.4 (a) Explain the structure of a B+ tree index. How is it different from a B Tree

index? Explain how updates are performed in both the types?

(b) What does the DBMS do when constraints are violated? What is

referential integrity? What options does SQL give application programmers

for dealing with violations of referential integrity?

Q.5 (a) Draw an ER diagram for a small marketing company database.

Assume suitable data.

(b) Define the concept of aggregation. Give several examples of where this

 concept is useful.

Q.6 (a) Explain deadlock prevention schemes?

(b) What are integrity constraints? Define the term primary key constraint

and foreign key constraint. How are these constraints expressed in SQL?

Q.7 Write short notes on:

(a) DBTG model

(b) ACID properties

(c) RAID

Scanned Copies:

Share This
Previous Post
Next Post

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!


Pen down your valuable important comments below

Search Everything Here