Question 1

In the relational DBMS augmented with BLOBs:

Accepted Answer

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 
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 2

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?

Accepted Answer

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 
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 3

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?

Accepted Answer

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 
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 4

CLASS Employee {
//Variables
String LastName;
String FirstName;
Real HourlyRate;
Integer HoursWorked;
Date HireDate;
String Job;
//Methods
Real Salary();
String GetLastName();
String GetFirstName();
String GetJob();}

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

Accepted Answer

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 
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 5

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

Accepted Answer

object definition la

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of In SQL:1999,the keyword ________________ in a method...

Question 9

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

Accepted Answer

The answer of One of the fundamental principles of object-oriented...

Question 10

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

Accepted Answer

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 
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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

object que

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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 
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 18

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?

Accepted Answer

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 
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 19

An implicit method of a user-defined type used to create an empty instance of that type is called a(n)_________________ method.

Accepted Answer

The answer of An implicit method of a user-defined type...

Question 20

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

Accepted Answer

A) True 
 B)False

In the relational DBMS augmented with BLOBs:

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?

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?

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

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.

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

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

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

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

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

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

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

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

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.

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.

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

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?

An implicit method of a user-defined type used to create an empty instance of that type is called a(n)_________________ method.

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

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Filters

Exam 18: Object Database Management Systems

In the relational DBMS augmented with BLOBs:

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?

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?

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

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.

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

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

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

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

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

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

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

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

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.

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.

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

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?

An implicit method of a user-defined type used to create an empty instance of that type is called a(n)_________________ method.

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

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Filters

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