Question 1

In the relational DBMS augmented with BLOBs:

Accepted Answer

In a relational DBMS augmented with BLOBs, external software is used to process the objects after retrieval. This is because BLOBs (Binary Large Objects) are typically image, audio, or video files that require specialized software for handling and processing. Storing them with other data would not be practical, and performance may be affected if large objects are retrieved frequently. Content indexes may be used to improve retrieval, but they are not the primary method of processing BLOBs. Therefore, option C is the best choice.

Question 2

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

Accepted Answer

The answer of Which of the following is not true...

Question 3

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

The answer of There is only one row with value...

Question 4

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

Accepted Answer

This row is deleted from table Tb and one row is deleted from table Ta and one row may be deleted from table Tc

Question 5

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

Accepted Answer

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

Question 6

Which of the following is an object relational DBMS?

Accepted Answer

Oracle 9i is an example of an object-relational database management system (DBMS), which combines features of both relational and object-oriented databases.

Question 7

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

The request is asking for a row to be inserted into table Tc with values 10, 20, and 30 respectively for ax, bp, and cm. This means that there should also be corresponding values for ax and bp in other tables. Therefore, a row will be created in Ta, Tb, and Tc with value ax = 10 in Ta, bp = 20 in Tb, and cm = 30 in Tc. This satisfies the request for inserting a row into Tc with the given values. Option A is not correct as the request can be executed. Option B is not correct as there should only be one row in Tc with the value of cm = 30. Option D is also not correct as there should be corresponding values for ax and bp in other tables.

Question 8

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

Accepted Answer

The answer of There is a request to delete the...

Question 9

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

Accepted Answer

Oracle 9i does not override methods in the same way that SQL:1999 does. The other options are true regarding Oracle 9i.

Question 10

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

Accepted Answer

The answer of Which of the following is not supported...

Question 11

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.

Accepted Answer

The answer of In a real estate listing service scenario,facts...

Question 12

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

Accepted Answer

Reliability is of utmost concern in today's object relational DBMS, as they are designed to handle large amounts of complex data, which often includes sensitive information. Therefore, options A, B, and D are applicable to today's object relational DBMS.

Question 13

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

Accepted Answer

The request is to insert a row into table Ta with value 50 for ax, which means only one row will be inserted in Ta with the given value for ax. There is no mention of any other tables or columns, so they will not be affected. Therefore, only option B is correct, which states that a row will be created in Ta with value 50 for ax and no row will be inserted in Tb.

Question 14

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

Accepted Answer

In the object-oriented DBMS approach followed by ODMG, the database is defined with the Object Definition Language (ODL) which is a language for defining the structure, behavior, and relationships of objects in the database. ODL is used to specify classes, attributes, methods, and constraints of objects. It is an integral part of the ODMG standard for object-oriented databases.

Question 15

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

Accepted Answer

All of the given options are object-oriented (ODMG) DBMS. Gemstone, Versant, and O2 are examples of such databases. Therefore, the correct choice is D.

Question 16

In the specialized media server approach to object DBMS:

Accepted Answer

In the specialized media server approach, application programs will contain both API calls to media servers for complex objects and SQL statements for usual data. This approach allows for more efficient processing of complex objects such as video data, but joint retrieval of usual data and complex data may still require careful consideration for performance.

Question 17

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

The request is asking to insert a row with values 4 and 3 for ax and bp respectively in table Tb. But since there is no column named ax in table Tb, it is assumed that there is a typo and the correct column name is bp. Therefore, a row will be created in both Ta and Tb with the same values of bp=3 in Tb and ax=4 in Ta.

Question 18

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

Accepted Answer

Storage management is the component of an object relational DBMS that is most similar to the corresponding component of a relational DBMS. This is because the storage management component of both types of DBMSs is responsible for managing the storage of data on disk.

Question 19

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

Accepted Answer

SQL2 is a relational database language and not an object-oriented language. The other choices, Java, C++, and Smalltalk, are all object-oriented languages.

Question 20

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

Accepted Answer

Today's object-oriented DBMS are designed to provide good performance for specific applications with complex data. While they may follow accepted standards, their focus is on addressing the unique requirements of complex data modeling and management. Traditional business applications can still benefit from this type of DBMS, but they are not the primary focus.

Quiz 18: Object Database Management Systems