Deck 9: Object-Oriented Database Management

Question 1

An instance of an object is an object class.

Answer 1

False

Question 2

The objects that describe similar entities are known collectively as a(n) ____.

A) file
B) class
C) UML diagram
D) OODBMS
E) operation

Answer 2

B

Question 3

An object/relational DBMS is essentially ____.

A) an environment in which separate relational and object-oriented DBMSs pass data to each other
B) a legacy DBMS
C) an advanced research concept that is not as yet commercially viable
D) an object-oriented DBMS with relational features
E) a relational DBMS with object-oriented features

Answer 3

E

Question 4

In the object-oriented concept, abstract data types ____.

A) can include simple numeric and alphabetic data types
B) cannot exist - they are strictly part of the relational concept
C) can have operations associated with them
D) are a disaster recovery feature
E) can only be implemented if the DBMS is of the object/relational type

Question 5

An object ____.

A) is the same thing as an entity
B) is a method or operation that acts on stored data
C) includes an entity's attributes plus methods or operations which can operate on the attribute values
D) is a rectangular box in an entity-relationship diagram
E) is a descriptive characteristic of a person, thing, or event in the business environment

Question 6

In a generalization/specialization relationship ____.

A) attributes can be inherited but operations cannot be inherited
B) operations can be inherited but attributes cannot be inherited
C) both attributes and operations can be inherited
D) neither attributes nor operations can be inherited
E) attributes can only be inherited if they are aggregated

Question 7

The modification or refinement of operations as they are inherited downwards in a generalization/specialization relationship is called ____.

A) polygraphism
B) polygenesism
C) polytrophism
D) polychromism
E) polymorphism

Question 8

Unified Modeling Language (UML) is ____.

A) another term for Entity-Relationship diagrams
B) a logical database design technique
C) a programming language used to access data stored in object-oriented databases
D) the standard diagramming notation for object-oriented systems development
E) a query language that is a substitute for SQL in the OODBMS environment

Question 9

Relational database management systems directly support ____.

A) complex relationships among different sub-categories or specialized categories of particular entities
B) situations in which particular entities are constructed from other component entities
C) the concept of particular data being updated only by a controlled set of program segments which are not in application programs
D) complex data types such as graphic images, photo images, video clips, and audio clips
E) tabular data such as accounting data

Question 10

Attributes in object classes in a generalization/specialization relationship ____.

A) cannot be inherited from one class to another
B) can be inherited from the general class to the specialized classes
C) can be inherited from the specialized classes to the general class
D) can be inherited from one specialized class to another specialized class
E) can be inherited from one general class to another general class

Question 11

Generalization/specialization relationships are a form of aggregation relationships.

Question 12

Aggregation relationships are handled naturally by relational DBMSs but generalization/specialization relationships are not.

Question 13

The object classes in a generalization/specialization relationship are arranged in a ____.

A) row
B) string
C) hierarchy
D) closed loop
E) linked list

Question 14

The term for the relationship in which a class is shown to be composed of other classes is ____.

A) generalization/specialization
B) aggregation
C) binary one-to-many
D) binary many-to-many
E) polymorphism

Question 15

All of the following are true about encapsulation, except ____.

A) it is designed to improve data integrity
B) it prevents application code outside of the encapsulated object from modifying the object's data
C) a message from an application program can trigger an encapsulated object
D) operations are stored in the database together with the data they operate on
E) objects can only be encapsulated if they are in an aggregation relationship

Question 16

The term for the relationship that recognizes that some kinds of entities can really be subdivided into smaller, more specific groups is ____.

A) generalization/specialization
B) aggregation
C) binary one-to-many
D) binary many-to-many
E) polymorphism

Question 17

All of the following kinds of data are candidates for abstract data types, except ____.

A) numeric data
B) video clips
C) audio clips
D) photo images
E) graphic images

Question 18

A potential exposure that can introduce errors in relational data is the ability of many application programs to manipulate shared data.

Question 19

The relational data model does not directly support such data types as photo images, video clips, and audio clips.

Question 20

An object is an advanced data structure that includes an entity's attributes plus methods which can operate on and modify the object's attribute values.

Question 21

Generalization/specialization is a relationship that recognizes that some kinds of entities can really be subdivided into smaller, more specialized groups.

Question 22

Methods or operations cannot be modified when they are inherited downwards.

Question 23

Draw an object-oriented class diagram, including traditional unary, binary and ternary relationships, as well as generalization and aggregation relationships as needed, to represent the following Central Zoo environment. Include all of the attributes and operations listed in the description.
Central Zoo has three kinds of enclosures: cages, fenced areas, and water tanks. Each enclosure, regardless of which kind it is, has a unique enclosure number and a location. In addition, each cage has an area (in square feet or square meters), a height, and a type, each fenced area has an area and a fence height, each water tank has a temperature. Each water tank is composed of two parts, a tank (the zoo keeps track of the volume of the tank) and a pump (the zoo keeps track of the number of amperes of the pump.)
Each animal that lives in a cage in the zoo has a unique animal number, a species, name, gender, and weight. Each cage can have several animals living in it or it can be empty. An animal can live in only one cage.
There is an operation that calculates the next cleaning date of each enclosure, but this calculation is different for cages, fenced areas, and water tanks.

Question 24

An object/relational database might include a table that has audio clip data in one of its columns.

Question 25

Aggregation is a special case of the generalization/specialization relationship.

Question 26

An object/relational DBMS is an OODBMS with relational features added to them.

Question 27

When an application program has to update encapsulated data, it sends a message to one of the object's encapsulated operations to trigger the operation.

Question 28

A video clip is an example of an abstract data type.

Question 29

An OODBMS allows associated operations to be defined along with abstract data types.

Question 30

An object class can only be encapsulated if it is involved in an aggregation relationship.

Question 31

In a generalization/specialization hierarchy, attributes are inherited downwards from the general object class to the specialized object classes.

Question 32

Generalization/specialization is a relationship that can be handled directly by an OODBMS.

Question 33

An OODBMS will only permit the attributes of an encapsulated object to be updated by its encapsulated methods or operations.

Question 34

Generalization/specialization is denoted in a UML diagram by an arrow pointing upward towards the "general" object class.

Question 35

Generalization/specialization is a relationship in which a class is shown to be composed of other classes.

Question 36

The Unified Modeling Language (UML) is the standard diagramming notation for object-oriented systems development.

Question 37

A BLOB (binary large object) is an example of generalization/specialization hierarchy.

Question 38

Aggregation is denoted by a diamond-shaped symbol in a UML diagram.

Question 39

The modification or refinement of methods or operations as they are inherited downwards is called polymorphism.

Question 40

In a generalization/specialization hierarchy, attributes can be inherited downwards from the general object class to the specialized object classes, but methods or operations cannot.

Question 41

Draw an object-oriented class diagram, including traditional unary, binary and ternary relationships, as well as generalization and aggregation relationships as needed, to represent the following Grand Travel Airlines environment. Include all of the attributes and operations listed in the description.
Grand Travel Airlines operates as both a passenger and a cargo airline. It has different kinds of planes for each of the two functions. For planes of both types it keeps track of each plane's top speed, length, and range. In addition, it keeps track of the capacity (number of seats) of each passenger plane and the capacity (in tons or metric tons) of each cargo plane.
Each passenger flight has a flight number, a date, departure time, and arrival time. A flight uses only one airplane while a particular plane is used on many flights.
Grand Travel Airlines has two kinds of passenger planes: jet and propeller driven. For the propeller driven planes it must keep track of the maximum revolutions per minute (RPM) of the propellers. Each jet plane is composed of three parts: the fuselage, the wings, and the engines. Grand Travel records the fuselage height and width, the wingspan (length) of the wings, and the number of engines and their maximum thrust.
An operation calculates the next maintenance date of each passenger plane, but the calculation is different for jet and propeller driven planes.