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

Q.1 What is data warehouse?

Q.2 What is DDBMS?

Q.3 Define Generalization of RDBMS?

Q.4 What is object oriented modaling?

Q.5 Define Serializablity?

Q.6 Write a short note on multimedia database?

Q.7 Define Temporal database?

Q.8 Define Triggers in SQL?

Q.9 What is intigrity contraints in RDBMS?

Q.10 State importance of security in database?

Q.11 Differentiate between internal & external sorting.

Q.12 Differentiate between stored procedure and function.

Q.13 What is data mining? Explain stages of data mining.

Q.14 Differentiate sequential,Random and index Sequential file organization.

Q.15 Explain all DDL statements used in SQL with syntax.

Q.16 What is Normalization in RDBMS? Explain 1NF,2NF,3NF and BCNF normal form with examples.

OR 

Write Short notes on :

(a) Cryptography and its types

(b) Association rules

Q.17 What is Query Optimization?Explain its processing.

OR

Draw and explain ER-diagram for library management system.

Q.18 Explain Error Handling in PL/SQL.

OR 

What is Concurrancy control in RDBMS?Explain various techniques of Concurrancy control.