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

3.10 network database model J. A major advantage in using a database management system
K. This person or group coordinates all related activities to control a database in an organization
L. Group of related fields
M. This model is composed of parent and child records (one parent to more than 1 child)
N. Software tool that facilitates creation and maintenance of database
O. The most popular kind of database model used on microcomputers



4. Each statement beneath has blank space to fit 1 of the word(s) or phrases in the list beneath. Enter your option in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

A. Larger B. INSERT C. Parallel search
D. Database E. Database Trigger F. Lost update
G. Inconsistent data H. 60% I. Record
J. Smaller K. Operating System L. 3NF
M. Users N. R-(R-S) O. Active data set
P. (U,-) Q. Base register addressing R. Tree

4.1 Suppose the domain set of an attribute consists of signed 4-digit numbers. There will be _________ of reduction in the storage of this attribute, if it is stored as an integer rather then character form.
4.2 Data items grouped together for storage purposes are called _________.
4.3 In a virtual memory system the address space specified by the address lines of the CPU must be _________ then the physical memory size and smaller than the secondary size.
4.4 The DBA is, in effect, the co-ordinator ranging from _________ and the users.
4.5 Give a relational algebra expression using only the minimum number of operators from (U,-) which is equivalent to R^S _________.
4.6 The _________ operation can not be performed using views when the defination includes more than 1 table.
4.7 The REVOKE command can not be used to revoke the privileges granted through the _________.
4.8 The data stored in cursor is called _________.
4.9 _________ are PL/SQL blocks that fire when an insert, update or delete performed on database.
4.10 _________ mode permits relocation without any change whatsoever the code.















PART TWO
(Answer any 4 questions)

5.
a) Explain the recovery procedure that needs to take place after disk crash.
b) Compare the 2 log-based recovery scheme in terms of ease of implementation and overhead cost.
(7+8)

6.
a) How does SQL allow implementation of entity, integrity and referential integrity constraints?
b) Define the subsequent terms
i) association
ii) relationship

Earning:   Approval pending.