Exam 18: Object Database Management Systems

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();} -An object of the class PartClerk is created for Lee (last name).Given the information shown,the method GetSalary:

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

An implicit method of a user-defined type used to change the value stored in an attribute is called a(n)______________ method.

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

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

In the specialized media server approach to object DBMS:

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.

Which of the following is an object relational DBMS?

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();} -The class Clerk does not inherit the following method from the class Employee:

In client-server processing:

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

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.

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.

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

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

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

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();} 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();} 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 employees with last names respectively Smith and Martin,which of the following statements is not true?

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

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.

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.