Maharashi Dayanand University (MDU) 2007 M.C.A Computer RDBMS - Question Paper

Q1.(a) What is DBMS? elaborate the advantages and disadvantages offered by such systems as compared to
file-processing system? discuss.

(b) What is schema and subschema? Why should a subschema be independent of schema? Also discuss
what is logical schema and physical schema and their differences.


Q2. (a) explain the role of E-R diagrams in the design of relational database. Illustrate your ans with
the help of an example.

(b) discuss why navigation is simpler in the relational data model than in any other data model with
examples.


Q3.(a) discuss the different operators of relational algebra with examples.

(b) What is SQL? discuss its use, purpose and importance through suitable examples.


Q4 (a) discuss what is meant by normalization and its advantages. discuss and describe
1NF,2NF,3NF,BCNF and 4NF by giving suitable examples for every.

(b) What are the main responsibilities of Database Administrator? discuss.


Q5. (a)What is concurrency? explain the different issues associated with DBMS.

(b) explain the locking techniques for concurrency control with examples.


Q6. (a) What is the difference ranging from DBMS and DDBMS? Also explain the advantages and disadvantages of
DDBMS.

(b) discuss with examples the replication and allocation techniques for design query processing in DBMS.


Q7. elaborate the general strategies for Query Processing? discuss .Also explain query optimization techniques
through suitable examples.


Q8. Write short notes on any 3 of the following:
a) Client-Server Architecture
b) Multiversion concurrency control techniques
c) Data fragmentation in DDBMS.
d) Database security RDBMS.

Earning:   Approval pending.