Code: A-30
Time: 3 Hours
Subject: DATABASE MANAGEMENT SYSTEMS
Max. Marks: 100

NOTE: There are 11 Questions in all.

  • Question 1 is compulsory and carries 16 marks. Answer to Q. 1. must be written in the space provided for it in the answer book supplied and nowhere else.
  • Answer any THREE Questions each from Part I and Part II. Each of these questions carries 14 marks.
  • Any required data not explicitly given, may be suitably assumed and stated.
    _____________________________________________________________________
Q.1       Choose the correct or best alternative in the following: (2x8)

a. In the architecture of a database system external level is the
 

(A) conceptual level.
(C) view level.

 (B) physical level.
(D) logical level.
b. In a relational model, degree is termed as
 

(A) number of rows.
(C) number of attributes.

(B) number of tables.
(D) number of candidate keys of the table.
c.

Relational algebra is a

 

(A) procedural language.
(C) Query Processing language.

 (B) non - procedural language.
(D) high level language.
d. In E-R diagram double ellipses represent
  (A) single attribute.
(C) multivalued attribute.
 (B) ) derived attribute.
(D) primary key attribute.
e. DBTG stands for
  (A) Data Base Task Group.
(C) ) Data Base Time Gap.
 (B) ) Data Base Total Garbage.
(D) Data Base Time Group.
f. In SQL for deletion of whole table the command used is
  (A) Delete tuples.
(C) Drop table.		 (B) Delete table.
(D) Drop tuples.

1
    Index    Next >>