B.Com-1 / B.Sc.-1 (Comp Voc) DBMS

Attempt any five questions in all. Selecting at least one question from each unit. All questions carry equal marks.

UNIT-I

Q.1 Explain database management system. What are the advantage of database system.       (13/15)

Q.2 Explain various data models in detail.                                                                               (13/15)

UNIT-II

Q.3 What is ER model? Explain it with suitable example.                                                     (13/15)

Q.4 Describe the following:-                                                                                                   (13/15) 

        (1) week and strong entity

        (2) specialization

        (3) Generalization

UNIT-III

Q.5 Explain the various JOIN options available in Access?                                                 (13/15)

Q.6 What is indexing? Explain the procedure for creating index.                                         (13/15)

UNIT-IV

     Q.7  Describe the following with suitable example:-                                                            (13/15)

   (1) DDL

  (2) DML

  (3) DCL

     Q.8(A) What is SQL?Explain its data types                                                                            (6/7)

  (B) Describe the following                                                                                                       (7/8)

  (1) Truncate & drop

  (2) Insert & update

UNIT-V

   Q.9 what do you mean by transaction explain its ACID properties.                                         (13/15)

   Q.10 Explain serialaizabilty and its type?                                                                                                           (13/15)