Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Which of the following is not viewed as a severe mismatch between a relational DBMS and a procedural programming language?
A)Retrieving the name of an employee with SQL and placing it in a program variable
B)Retrieving the rows of newly hired employees from a table customer and storing them in a program data structure
C)Storing a program-defined hexagon in a relational DBMS
D)Comparing two pictures for similarity
2

Polymorphism does not:
A)Refer to the possible binding of a method in a message with one of several implementations
B)Make the programming of messages more complex
C)Support incremental modification of code
D)Support reusability
3

Which of the following is true of early object DBMS?
A)Access to data was done by procedural languages
B)They extended existing object-oriented languages through persistency of objects
C)They were used mostly for large and complex kinds of data
D)All of the above
4

Which of the following is not true of the object database middleware approach?
A)The usual data and complex (e.g. media) data reside on the same database
B)The client issues SQL statements for both usual data and complex data
C)The object middleware issues the API calls for the complex data
D)Combined requests for usual and complex data are not optimized
5

Which of the following object-oriented approaches involves the most substantial changes to a relational DBMS?
A)Object Database Middleware
B)BLOBs and external software
C)User-defined types
D)Specialized media servers
6

In the object-oriented DBMS (as distinguished from the object relational DBMS) under study by ODMG:
A)The database is processed with the OQL language
B)The database is processed with the ODL language
C)The database is processed with SQL:2003
D)The database is processed with proprietary software
7

Which of the following is an object–oriented (ODMG) DBMS?
A)Gemstone
B)Versant
C)O2
D)All of the above
8

Which of the following is true about SQL:2003?
A)It is possible to list data from tables Tx and Ty in a SQL:2003 query without having Ty appearing in the query
B)An attribute may be of a type defined by a user
C)An attribute may consist of an array of values
D)All of the above
9

Which of the following is not true regarding Oracle 10g:
A)Oracle 10g supports user-defined types using a syntax which is close to the SQL:2003 syntax
B)Oracle 10g supports most of the features of the SQL:2003 object packages
C)Oracle 10g claims enhanced SQL:2003 conformance
D)None of the above
10

Which of the following is true regarding Oracle 10g:
A)Oracle 10g specifies object identifiers in the same way that SQL:2003 does
B)Oracle 10g does not support reference types for columns like SQL:2003 does
C)Oracle 10g does not support subtables like SQL:2003 does
D)None of the above







Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 18 > Multiple Choice Quiz