model test paper Bcom II Year rdbms

B.Com. (II Year) Examination

RELATIONAL DATABASE MANAGEMENT SYSTEMS
(computers)



Time :3 Hours] [Max. Marks :70

Section A -(Marks : 5 x 4 = 20)

I. Answer any five of the following in not more than 1 page each:-

(a) Define DBMS.

(b) What are the stages of database development life cycle?

(c) What is E-R model?

(d) Define attributes and explain its types.

(e) Define a table.

(f) What is DDL ? List out DDL commands.

(g) What are the goals of DBA ?

(h) What is a distributed database system ?

Section B- (Marks : 5 x 10 = 50)

Answer all questions in about five pages each.

2.(a) Explain the database management systems components.

OR

    (b) Explain the risks and costs of database.

3.(a) Explain the principles of conceptual database design.

OR

    (b) What is normalization ? Explain 1NF,2NF,3NF

4.(a) Explain the various data types in SQL.

OR

    (b) Write about client /server database system.

5.(a) Explain various files organizations.

OR

   (b) Discuss data storage formats on disk.

6.(a) Write about distributed query processing .

OR

  (b) Explain the different DBMS functions and capabilities.