Maharashi Dayanand University (MDU) 2007 M.C.A Computer RDBMS - exam paper

Q1. discuss the terms:-
Database and DBMS with examples.
discuss the 3 schema architecture of a DBMS with the help of diagram. Why do we need
mappings ranging from the various schema levels? Also discuss the main advantages of DBMS examples.

Q2. (a) describe the term E-R-diagram. discuss the different kinds of relationship in a E-R- diagram.
Draw an E-R-diagram for taking your own example.

(b) discuss the different operators available in Relational Algebra with the help of examples.

Q3. (a) What is meant by Normailzation? discuss and describe the different kinds of Normal forms with the help
of suitable examples. Also discuss the advantages of normalization.

(b) What is SQL? discuss the purpose and use of SQL in RDBMS. Also explain the basic structure of an
SQL expression.

Q4. explain the subsequent concurrency control techniques with examples:
(a) Locking Techniques.
(b) Techniques based on time-stamp ordering.
(c) Multiversion conversion control techniques.

Q5. What is meant by Query Processing? explain the different methods for query optimization with the help of
suitable examples.

Q6. Write short notes on following:-
(a) Overview of Client Server System,
(b) Data Fragmentation in DBMS,
(c) Replication and Allocation techniques for query processing in DBMS.


Q7. (a) elaborate the main responsibilities of DBA? discuss.

(b) How the performance of database is affected by the following:-
1-Data Migration,
2-Tunning of Database

(C) Differentiate ranging from the DDL and DML.

Q8. Write short notes on any 3 with examples:--
(a) Full/Partial/Transitive dependencies,
(b) Various issues associated with concurrency control in DBMS,
(c) Differences ranging from DBMS and DDBMS,
(d) Database security and RDBMS.

Earning:   Approval pending.