DOEACC Society 2007 DOEACC A Level A7-R3 Introduction to Data Base Management Systems - Question Paper

A7-R3: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
NOTE:
1. There are 2 PARTS in this Module/Paper. PART 1 contains 4 ques.
and PART 2 contains 5 ques..
2. PART 1 is to be answered in the TEAR-OFF ans SHEET only, attached to
the ques. paper, as per the instructions contained therein. PART 1 is NOT to
be answered in the ans book.
3. Maximum time allotted for PART 1 is 1 HOUR. ans book for PART TWO
will be supplied at the table when the ans sheet for PART 1 is returned.
However, candidates, who complete PART 1 earlier than 1 hour, can collect the
ans book for PART 2 immediately after handing over the ans sheet for
PART ONE.
TOTAL TIME: three HOURS TOTAL MARKS: 100
(PART 1 – 40; PART 2 – 60)
PART ONE
(Answer all the questions)
1. every 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 A schema defines
A) Record Relationship
B) Data Elements
C) Record and files
D) All of the above
1.2 The physical location of a record is determined by a mathematical formula that transforms a
file key in to a record location in
A) A B-Tree File
B) An indexed file
C) A hashed file
D) None of the above
1.3 An abstraction concept for building composite objects from their component object is called
A) Specialization
B) Normalization
C) Generalization
D) Aggregation
1.4 The JOIN operator can be specified as
A) Rx S
B) s (condition) (RxS)
C) Both A) and B)
D) None of the above
A7-R3 Page one of six January, 2007
1.5 The expression (RUS)-((R-S)U(S-R)) is equivalent to
A) R / S
B) R Ç S
C) s (condition) (RxS)
D) p(RxS)
1.6 A statement that is executed automatically by the system as a side effect of a
modification to the database is known as
A) Assertion
B) Triggers
C) Referential constraints
D) None of the above
1.7 An audit trail
A) Can be used to restore lost info
B) Is used to make backup copies
C) Is the recovered history of operations performed on a file
D) All of the above
1.8 A model used to define data at the logical and view level
A) Object based logical models
B) Record based logical models
C) Physical models
D) None of the above
1.9 A normal form in which every determinant is a key
A) 2NF
B) 3NF
C) BCNF
D) 4NF
1.10A property which ensures that every functional dependency is represented in a few
individual relation resulting after decomposition
A) Loss less join

Earning:   Approval pending.