Exam 18: Object Database Management Systems

CLASS Employee { //Variables String LastName; String FirstName; Real HourlyRate; Integer HoursWorked; Date HireDate; String Job; //Methods Real Salary(); String GetLastName(); String GetFirstName(); String GetJob();} -The ability by a program do to the following violates encapsulation principles:

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

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

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.

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

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

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

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

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

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

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

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

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

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 is an object for a clerk with last name Lopez,the following method will be used to compute Lopez's salary:

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.

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

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 data from the class Employee:

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

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

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