Exam 18: Object Database Management Systems

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

CLASS Employee { //Variables String LastName; String FirstName; Real HourlyRate; Integer HoursWorked; String Job; Date HireDate; Real Monthly_Salary; //Methods String GetLastName(); String GetFirstName(); String GetJob(); Real GetSalary();} The class Clerk is a subclass of the class Employee CLASS Clerk: Employee { //Variables Real HourlyRate; Integer HoursWorked; //Methods Real GetSalary();} The class Salesperson is a subclass of the class Employee CLASS Salesperson: Employee { //Variables Real Base_Salary; Real Commission_rate Real Sales; //Methods Real GetSalary();} The class PartClerk is a subclass of the classes Clerk and Salesperson CLASS PartClerk: Clerk, Salesperson { //Variables Real PercentClerk; //Methods Real GetPercentClerk();} -If there are two clerks with identical data (same last name,first name,...):

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

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

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

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

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

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

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

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

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

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

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.

Which of the following requires object database technology?

In SQL:1999,a(n)_______________ is an alternative table definition that references a user-defined type instead of listing column names and associated data types.

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

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

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

CLASS Employee { //Variables String LastName; String FirstName; Real HourlyRate; Integer HoursWorked; Date HireDate; String Job; //Methods Real Salary(); String GetLastName(); String GetFirstName(); String GetJob();} -Which of the following is not part of the interface?

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