BCA | RDBMS(Relational Database Management System) 2023 Paper | MDSU Exam Paper

1- What is data abstraction?

2- What is DML?

3- What do you understand by mapping constraint?

4- Discuss the need of recovery in DBMS?

5- What is Class?

6- What is DKNF?

7- Define package?

8- What is relational algebra?

What do you understand by security specification in SQL?

10- What do you mean by access control in DBMS?

11- What are the roles of 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.

16- Design an ER diagram of Library Management system?

OR

What is normalization? Discuss all its normal forms?

17- 

(1) What do you understand by two phase locking? Explain its advantages.

(ii) Discuss the architecture of distributed processing system.

OR

(1) Explain the concurrency control techniques?

(ii) What do you mean by transaction management in DBMS?

18- 

What do you understand by triggers? Explain its all 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?