August 1997
DB212: DATABASE MANAGEMENT SYSTEMS

QUESTION 1 (Compulsory)

Total Marks: 20 Marks

Click here to access other questions

SUGGESTED SOLUTIONS
Solutions and allocated marks are indicated in green.
Return to Question 1

1. From the possible answers given, select the single correct answer. Note that marks will not be deducted for incorrect answers.
Parts (a) to (d) are based on the following figure:
(a) How many SHIPMENTs are there for each CUSTOMER? [2]
(i) zero (iv) one or more
(ii) one (v) none of the above
(iii) zero or more
iii
(b) Which of the following is a method? [2]
(i) PASSENGER (iii) ScheduleFlight
(ii) Name (iv) none of the above
iii
(c) How many CUSTOMERs are there for each AIRLINE? [2]
(i) zero or more (iv) not shown in the diagram
(ii) one or more (v) none of the above
(iii) more than one
iv
(d) Which of the following is an attribute? [2]
(i) CUSTOMER (iv) CalculateWt
(ii) ScheduleFlight (v) two of the above
(iii) Item No
iii
(e) Which of the following is not a current concern or limitation of object-oriented DBMS technology today? [2]
(i) lack of accepted standards (iv) inability to model complex data structures
(ii) lack of development tools (v) all of the above are concerns
(iii) performance
iv
(f) The state of an object is expressed by: [2]
(i) the values of the attributes of the object (iii) the message connections between objects
(ii) the methods that operate on the attributes (iv) a message map showing the flow of objects
(v) none of the above
i
(g) The behaviour of an object is defined by: [2]
(i) the values of the attributes of the object (iii) the message connections between objects
(ii) the methods that operate on the attributes (iv) application programs that access the objects
(v) none of the above
ii
(h) The property that the attributes and methods of an object are hidden from the outside world and do not have to be known to access its data values or invoke its methods is: [2]
(i) generalization (iv) information hiding
(ii) inheritance (v) none of the above
(iii) encapsulation
iii
(i) The attributes and methods for each object are stored in: [2]
(i) an object instance (iv) an object repository
(ii) an object connection (v) none of the above
(iii) an assembly structure
iv
(j) The property that, when classes are arranged in a hierarchy, each class assumes the attributes and methods of its ancestors is: [2]
(i) generalization (iv) information hiding
(ii) inheritance (v) none of the above
(iii) encapsulation
ii
two marks for each part. No negative marking for wrong answers
[20 marks]