BCA | DBMS 2022 Paper | MDSU Exam Paper

BCA || PART-2 || DBMS(Database Management System) 2022 Paper | MDSU Exam Paper :

SECTION - A
Q-1. What is DBA?
Q-2. Define entity.
Q-3. What do you mean by filter?
Q-4. What do you mean by queries?
Q-5. What is the size limitation for MS access database?
Q-6. What is report in database?
Q-7. What is data sheet view?
Q-8. What is a sub-form?
Q-9. How many relationships are possible between two entities?
Q-10. Define Many to Many relationship.

SECTION - B
Q-11.What is distributed database?
Q-12.What are integrity constraints?
Q-13.List various types of attributes.
Q-14.Explain how to create a table in MS-Access.
Q-15.Explain primary key and foreign key.

SECTION - C
Q-16. Briefly explain various types of database models. OR Design an ER diagram for a university registrar's office. The office maintains data about each class, including the instructor, the enrollment, time, and place of the class meeting.
Q-17. Explain different set operations in relational algebra with an example. OR Explain DDL, DML, and DCL using examples.
Q-18. Describe the process of creating a report through a wizard. OR Explain the following with their uses in a form: (a) Combo Box (b) Option Button (c) Check Box.