Deck 18: Object Database Management Systems

Question 1

Currently,there is no unified standard that allows portability between SQL:1999 and ODMG-compliant DBMSs.

Answer 1

True

Question 2

When an object receives a request to execute a method,if the object's class does not contain that method,the request is forwarded to the parent class for execution.

Answer 2

True

Question 3

Class reusability and data independence are two of the benefits of encapsulation.

Answer 3

True

Question 4

In the object relational approach,complex data such as video data are not processed through commands of the database language.

Question 5

The principle of encapsulation in object-oriented programming means that the internal details of an object are not accessible through their interface.

Question 6

The current object DBMSs differ from their predecessors in that access to data can now be done with nonprocedural languages such as SQL.

Question 7

In object database middleware approach,SQL queries are used to retrieve simple and complex data.

Question 8

The Object Data Management Group specifies the standard for object relational DBMSs.

Question 9

An object-oriented DBMS is a good choice for traditional business applications that require ad hoc query capabilities,query optimization,and efficient transaction support.

Question 10

In object-oriented programming,a method implementation contains the inputs and outputs of the method,while a method interface contains the detailed coding of the method.

Question 11

In object-oriented computing,the programming language is responsible for ensuring that objects and methods are compatible.

Question 12

The need to integrate complex data,such as images,audio and video,with simple data,such as dates and numbers,is the driving force behind object database technology.

Question 13

Although it will take time for vendors to implement,SQL:1999 is expected to become the dominant standard for object database management,given the dominance of SQL-92 in today's market.

Question 14

Class reusability and improved organization of software are two of the benefits of inheritance.

Question 15

Two advantages of object relational DBMSs are their integration of simple and complex data,and their reliability with user-defined functions and storage structures.

Question 16

In both the large object architecture and the specialized media server architecture,SQL queries are used to retrieve and display complex data.

Question 17

Both the large object architecture and the specialized media server architecture may exhibit poor performance because query optimization and indexing on complex objects are not available.

Question 18

In addition to user-defined types,object relational databases support other object features such as subtable families,and array and row data types.

Question 19

In the object relational approach,the database language integrates the processing of simple data and data of types defined by the users.

Question 20

In object-oriented computing,the object DBMS is responsible for binding a message to the appropriate method implementation.

Question 21

If there is an object for a clerk with last name Lopez,the following method will be used to compute Lopez's salary:

A) The method GetSalary defined in the class Clerk
B) The method GetSalary defined in the class Employee
C) A new method GetSalary, which was created for that object, when the object for Lopez was created
D) There is ambiguity, and the program must tell the system which method to use

Question 22

Which of the following applications is supported by a relational DBMS?

A) Identifying the code number of a spare part using a drawing of the spare part
B) Listing the suppliers of a spare part identified by its code number
C) Showing how to dismount an automobile part
D) All of the above

Question 23

If there are two clerks with identical data (same last name,first name,...):

A) Only one object is created
B) An error occurs when the program tries to create a second object with the same data
C) The program appends a unique identifier at the end of LastName of the second employee
D) Two objects are created, which are differentiated by a unique system-generated identifier

Question 24

The class Clerk does not inherit the following data from the class Employee:

A) The variable LastName
B) The variable HourlyRate
C) The variable Job
D) The variable HireDate

Question 25

SQL:1999 supports the definition of structured data types,which are used to bundle a collection of attributes and methods together.

Question 26

Since Oracle 9i differs from SQL:1999 in that system-generated object identifiers are not explicitly named,the REF function must be used in data manipulation statements in Oracle 9i to retrieve the object identifier.

Question 27

The class Clerk does not inherit the following method from the class Employee:

A) The method GetLastName
B) The method GetFirstName
C) The method GetSalary
D) The method GetJob

Question 28

If the type of the data HoursWorked is changed from integer to real,the following will need to be changed:

A) A program that displays an Employee's name and salary
B) The method Salary()
C) All of the above
D) None of the above

Question 29

Which of the following applications is supported by an object DBMS?

A) Identifying the code number of a spare part using a drawing of the spare part
B) Listing the suppliers of a spare part identified by its code number
C) Showing how to dismount an automobile part
D) All of the above

Question 30

Oracle 9i follows the SQL:1999 standard in supporting row types,subtables and typed tables.

Question 31

If there are two employees with last names respectively Smith and Martin,which of the following statements is not true?

A) Two objects of the class Employee may be created to represent these two employees
B) Only one object of the class Employee may exist at a given time
C) To get the last name of an employee, the method GetLastName will be sent to the object representing that employee
D) To get the job of an employee, the method GetJob will be sent to the object representing that employee

Question 32

The ability by a program do to the following violates encapsulation principles:

A) Directly Access LastName
B) Retrieve LastName with method GetLastName();
C) Retrieve Job with the method GetJob();
D) Compute salary with method Salary()

Question 33

SQL-1999 supports multiple inheritance of subtypes by allowing more than one type name to be listed after the UNDER keyword in the CREATE TYPE statement.

Question 34

Oracle 9i,differs from SQL:1999 in that if two methods have the same name but different signatures (i.e.number,types,and order of parameters)there is no overriding of the methods in Oracle9i.

Question 35

Only methods that have been explicitly defined in the CREATE TYPE statement of a user-defined type can be used in SQL statements and stored procedures.

Question 36

An object of the class PartClerk is created for Lee (last name).Given the information shown,the method GetSalary:

A) Is the one defined in Employee
B) Is the one defined in Clerk
C) Is the one defined in Salesperson
D) Cannot be determined

Question 37

In client-server processing:

A) A client may be viewed as an object
B) Objects may be distributed on different computers
C) The DBMS ensures proper binding of a method
D) All of the above

Question 38

In SQL:1999,functions and procedures can overcome some of the limitations of SQL:1999 methods.

Question 39

Which of the following is not part of the interface?

A) Real Salary();
B) String GetLastName();
C) Date HireDate
D) String GetFirstName();

Question 40

Which of the following requires object database technology?

A) Storing an employee picture on disk
B) Retrieving an employee picture
C) Retrieving and processing an employee picture together with simpler data about the employee
D) Displaying an employee picture on a screen

Question 41

In the relational DBMS augmented with BLOBs:

A) Large objects are stored with the other data
B) Performance is excellent
C) External software is used to process the objects after retrieval
D) Content index are used to retrieve the objects

Question 42

Which of the following is not true of the object database middleware approach?

A) The usual data and complex (e.g. media) data reside on the same database
B) The client issues SQL statements for both usual data and complex data
C) The object middleware issues the API calls for the complex data
D) Combined requests for usual and complex data are not optimized

Question 43

There is only one row with value ax = 100 in Ta.If there is a request to delete that row,which of the following is true?

A) At most one row may be deleted from Tb
B) Several rows may be deleted from Tb
C) No rows may be deleted from Tb
D) No rows may be deleted from Ta if it has a corresponding row in Tb

Question 44

There is a request to delete the only row with value bp = 50 from table Tb.Which of the following statements is true?

A) This row is deleted from table Tb and no rows are deleted from the other tables
B) This row is deleted from table Tb and one row is deleted from table Ta and no rows may be deleted from table Tc
C) This row is deleted from table Tb and one row is deleted from table Ta and one row may be deleted from table Tc
D) This request may not be satisfied

Question 45

A(n)_______________ is a combination of data and procedures.

Question 46

Which of the following is an object relational DBMS?

A) Gemstone
B) Oracle 9i
C) O2
D) Microsoft Access

Question 47

There is a request to insert a row into table Tc with values 10,20,30 respectively for ax,bp,cm.Which of the following will take place?

A) The request cannot be executed
B) A row will be created in Tb and Tc (the "same" row) with value bp = 20 in Tb, and cm = 30 in Tc
C) A row will be created in Ta, Tb and Tc (the "same" row) with value ax = 10 in Ta, bp = 20 in Tb, and cm = 30 in Tc
D) Only one row will be created in Tc with value cm = 30

Question 48

There is a request to delete the only row with value cm = 30 from table Tc.Which of the following statements is true?

A) This row is deleted from table Tc and no rows are deleted from the other tables
B) This row is deleted from table Tc and one row is deleted from table Tb and no rows are deleted from table Ta
C) The request may not be satisfied
D) This row is deleted from table Tc and one row is deleted from table Tb and one row from Table Ta

Question 49

Which of the following is not true regarding Oracle 9i:

A) Oracle 9i supports inheritance for user-defined types similar to SQL:1999
B) Oracle 9i overrides methods in the same way that SQL:1999 does
C) Oracle 9i supports order methods for direct object to object comparisons
D) None of the above

Question 50

Which of the following is not supported by Oracle 9i:

A) row types
B) typed tables
C) subtables
D) All of the above

Question 51

In a real estate listing service scenario,facts about homes such as price,square feet and number of bedrooms are examples of ___________ data,while photographs,floor plans and video tours are examples of ____________ data.

Question 52

Which of the following statements does not apply to today's object relational DBMS?

A) Calls to functions that process media data are part of the database language command
B) Specialized storage structures are provided
C) Reliability is of no concern
D) Combined access to complex data and relational data is optimized

Question 53

There is a request to insert a row into table Ta with value 50 for ax.Which of the following will take place?

A) The request cannot be executed
B) A row will be created in Ta with value 50 for ax and no row will be inserted in Tb
C) A row will be created in Ta, Tb (the "same" row) with value ax = 50 and null value for bp in Tb
D) A row will be created in Ta, Tb, Tc (the "same" row) with value ax = 50 and null value for bp in Tb and for cm in Tc

Question 54

In the object-oriented DBMS (as distinguished from the object relational approach)under study by ODMG:

A) The database is defined with the OQL language
B) The database is defined with the ODL language
C) The database is defined with SQL:1999
D) The database is defined with proprietary software

Question 55

Which of the following is an object-oriented (ODMG)DBMS?

A) Gemstone
B) Versant
C) O2
D) All of the above

Question 56

In the specialized media server approach to object DBMS:

A) Transaction processing involves both complex objects and usual data
B) Application programs will contain both API calls to media servers for complex objects and SQL statements for usual data
C) Processing of complex objects such as video data has poor performance
D) Joint retrieval of usual data and complex data is performed efficiently

Question 57

There is a request to insert a row in Tb with values 4,3 respectively for ax and bp.Which of the following will take place?

A) The request cannot be executed
B) A row will be created in Ta and Tb (the "same" row) with value bp = 3 in Tb, and ax = 4 in Ta
C) Only one row will be created in Tb with value bp = 3
D) Only one row will be created in Ta with value ax = 4

Question 58

The component for the following function of an object relational DBMS hardly differs from the corresponding component of a relational DBMS:

A) Parser
B) Storage management
C) Optimizer
D) Display manager

Question 59

Which of the following is not an object-oriented language?

A) SQL2
B) Java
C) C++
D) Smalltalk

Question 60

Today's object-oriented DBMS (as distinguished from object relational DBMS):

A) Follow an accepted standard
B) Provide good performance for traditional business applications
C) Provide good performance for specific applications with complex data
D) All of the above

Question 61

In object-oriented programming,the ability of an object to have multiple implementations is referred to as ____________________.

Question 62

For object-oriented DBMSs,the two languages that are the counterpart for SQL in relational DBMSs are ________________________ and __________________________.

Question 63

The ability to ensure that programming code does not contain incompatibility errors is known as __________________.

Question 64

The object relational DBMS architecture contains a(n)____________________ which handles transaction processing,storage management,and buffer management.

Question 65

In SQL:1999,the keywords ___________________ are used to define a new structured data type.

Question 66

In SQL:1999,the keyword ______________ followed by a type name in a CREATE TYPE statement indicates that the type being defined is a child of the named parent type.

Question 67

A new kind of DBMS in which both the data model and the kernel have been changed to accommodate objects is a(n)_________________________.

Question 68

___________ binding binds a method name with a method implementation at the time of compilation of the program.

Question 69

___________ binding binds a method name with a method implementation at the time of execution of the message.

Question 70

A(n)______________ definition is a collection of variables and methods.

Question 71

In SQL:1999,the keyword ________________ in a method definition indicates that the child method being defined overrides the definition in the parent type.

Question 72

An architecture that involves storage of large objects in a database along with external software to manipulate the large objects is known as __________________________.

Question 73

An architecture that uses a dedicated server to manage complex data outside of a database is called ______________________________.

Question 74

A relational DBMS that has been extended to include an object query processor for user-defined types is a(n)_______________________.

Question 75

One of the fundamental principles of object-oriented computing is _________________,which means that an object can only be accessed through its interface.

Question 76

Any complex data such as images,time series,and video can be added to an object relational DBMS as a(n)____________________.

Question 77

_____________________ in object-oriented programming refers to the sharing of data and code among similar classes.

Question 78

To request the execution of a method,a(n)_______________ containing a method name and parameters is sent to an object.

Question 79

The object relational DBMS architecture contains a(n)____________________,which includes a parser to decompose references to expressions containing user-defined types and functions,and an optimizer to optimize these references.

Question 80

An architecture that uses middleware to manage complex data stored outside of a database along with simple data stored in a DBMS is referred to as ______________________.