BCA | RDBMS 2023 Paper | MDSU Exam Paper

BCA || PART-3 || RDBMS(Relational Database Management System) 2023 Paper || MDSU Exam Paper :

SECTION-A
1- What is data abstraction?
2- What is DML?
3- What do you understand by mapping constraint?
4- Discuss the need for recovery in DBMS?
5- What is a Class?
6- What is DKNF?
7- Define package?
8- What is relational algebra?
9- What do you understand by security specifications in SQL?
10- What do you mean by access control in DBMS?

SECTION-B (Compulsory)
11- What are the roles of a database administrator?
12- Differentiate between generalization and specialization in DBMS.
13- What do you understand by DDBMS? Explain.
14- What are database recovery techniques? List the names of any two recovery techniques.
15- What is cryptography? Discuss it in brief.

SECTION-C
16- Design an ER diagram for a Library Management system? OR What is normalization? Discuss all its normal forms.
17- (i) What do you understand by two-phase locking? Explain its advantages. (ii) Discuss the architecture of a distributed processing system. OR (i) Explain the concurrency control techniques. (ii) What do you mean by transaction management in DBMS?
18- What do you understand by triggers? Explain all its types and also give one example. OR What do you understand by error handling or exceptions in PL/SQL? List the names of any three pre-defined exceptions in PL/SQL and give one illustrative example.