BCA | DBMS(Database Management System) 2022 Paper | MDSU Exam Paper

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.

Q-11.What is distributed database?

Q-12.What is the integrity constraints?

Q-13.List various types of attributes:

0-14.Explain how to create table in MS-Access

Q-15.Explain primary key and foreign key.

Q-16. Briefly explain various types of database models.

OR

Design an ER diagram for university registrar's office. The office maintains data about each class, including the instructor, the enrolment, time and place of the class meeting.

Q-17. Explain different set operations in relational algebra with an example.

 Explain DDL, DML and DCL using example.

Q-18. Describe process of creating report through wizard.

OR

Explain following with their uses in form

(a) Combo Box

(b) Option Button

(c) Check Box