DOEACC Society 2007 Advanced Level Course In Computer Science A7-R3: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS - Question Paper

TOTAL TIME: three HOURS TOTAL MARKS: 100
(PART ONE-40; PART 2 – 60)

PART ONE
(Answer all the questions)

1. Each ques. beneath provide a multiple option of answers. select the most improper 1 and enter in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

1.1 The DMLs which require a user to specify what data is needed and how to get it, is called
A) DDL DMLs
B) Procedural DMLs
C) Nonprocedural DMLs
D) None of the above

1.2 One of the subsequent is not an object-based logical model.
A) The binary model
B) The entity-relational model
C) The infological model
D) None of the above.

1.3 A super key is a set of 1 or more attributes that, taken collectively, allow us
A) to identify uniquely an entity in the entity set.
B) to make the key most powerful for faster retrieval.
C) to increase effectiveness of database access.
D) None of the above.

1.4 Which 1 of the subsequent is binary operation?
A) project
B) select
C) rename
D) None of the above











1.5 Consider P1 and P2 are formulae. Which 1 of the subsequent is accurate ?
A) P1 ^ P2 is equivalent to ? (P1 V ? (?P2))
B) P1 ^ P2 is equivalent to ? (?(P1) V ? (P2))
C) P1 ^ P2 is equivalent to ? (?(P1) V ? (?P2))
D) None of the above.

1.6 Which clause from the subsequent corresponds to the projection operation of the relational algebra.
A) from
B) select
C) where
D) None of the above.

1.7 Which 1 of the clause is useful in defining the notion of tuple variables?
A) as
B) by
C) from
D) None of the above.

1.8 The intersect operation
A) automatically eliminates duplicates.
B) automatically eliminates duplicates, if we give all clause with intersect.
C) never eliminates duplicates.
D) None of the above.

1.9 A table is in 2NF if it is in 1NF and if
A) no column that is not a part of the primary key is dependent on only a portion of the alternate key.
B) no column that is not a part of the primary key is dependent on only a portion of the primary key.
C) no column that is not a part of the primary key is dependent on only a portion of the foreign key.
D) None of the above.

1.10 The JOIN command in the relational algebra combines data from 2 tables based on
A) common rows.
B) common columns.
C) Predefine rules
D) None of the above.

Earning:   Approval pending.