Question 1

One of the advantages of the call-level API approach is the small amount of code needed to be written.

Accepted Answer

A) True 
 B)False

Question 2

SQL ________ frameworks provide a set of tools that provide persistence by linking classes to parameters and results of SQL queries.

Accepted Answer

The answer of SQL ________ frameworks provide a set of...

Question 3

All of the following are elements of the object-relational impedance mismatch EXCEPT:

Accepted Answer

A)  nature and granularity of data types. 
B)  methods of assessing non-persistent data. 
C)  architectural styles. 
D)  structural relationships. 
A)  nature and granularity of data types. 
B)  methods of assessing non-persistent data. 
C)  architectural styles. 
D)  structural relationships.

Question 4

The process of using a limited number of database connections that are shared by multiple applications and users is called pooling of database connections.

Accepted Answer

A) True 
 B)False

Question 5

A performance problem caused by too many select statements generated by an ORM framework is called:

Accepted Answer

A)  N+J selects problem. 
B)  N* selects problem. 
C)  N+1 selects problem. 
D)  selection classification problem. 
A)  N+J selects problem. 
B)  N* selects problem. 
C)  N+1 selects problem. 
D)  selection classification problem.

Question 6

ORM frameworks have the responsibility for generating ________.

Accepted Answer

The answer of ORM frameworks have the responsibility for generating...

Question 7

What are some of the typical responsibilities of an Object-Relational Mapping Framework?

Accepted Answer

Typical responsibilities are:
1.Provide

Question 8

All of the following are typical responsibilities of the ORM framework EXCEPT:

Accepted Answer

A)  generating SQL code for database access. 
B)  query language. 
C)  distributing code related to database access. 
D)  providing a layer of abstraction. 
A)  generating SQL code for database access. 
B)  query language. 
C)  distributing code related to database access. 
D)  providing a layer of abstraction.

Question 9

A persistent solution that hides the underlying storage technology is called:

Accepted Answer

A)  object persistence. 
B)  translucent persistence. 
C)  transparent persistence. 
D)  object permanence. 
A)  object persistence. 
B)  translucent persistence. 
C)  transparent persistence. 
D)  object permanence.

Question 10

Transparent persistence is a solution that hides the underlying storage technology.

Accepted Answer

A) True 
 B)False

Question 11

Persistence defines an object's capability to maintain its ________ between application execution ________.

Accepted Answer

The answer of Persistence defines an object's capability to maintain...

Question 12

In both table per concrete class approaches there is no table representing the ________ superclass.

Accepted Answer

The answer of In both table per concrete class approaches...

Question 13

One advantage of the call-level API approach to providing persistence is:

Accepted Answer

A)  low overhead. 
B)  ability to not write a lot of detailed code. 
C)  SQL code is generated automatically. 
D)  does provide transparent persistence. 
A)  low overhead. 
B)  ability to not write a lot of detailed code. 
C)  SQL code is generated automatically. 
D)  does provide transparent persistence.

Question 14

Serialization is not a realistic method for storing large amounts of structured data.

Accepted Answer

A) True 
 B)False

Question 15

Object-oriented environments typically do not have an inherent,built-in concept of boundaries between ________.

Accepted Answer

The answer of Object-oriented environments typically do not have an...

Question 16

The conceptual differences between the object-oriented approach to application design and the relational model for database design is called the ________.

Accepted Answer

object-rel

Question 17

The relational database approach is based on the same architectural assumptions as the object-oriented approach.

Accepted Answer

A) True 
 B)False

Question 18

Storing the state of an object between application execution sessions is called providing ________ to the object.

Accepted Answer

A)  stateness 
B)  persistence 
C)  quality 
D)  data 
A)  stateness 
B)  persistence 
C)  quality 
D)  data

Question 19

Relational databases and the processes that are used to design them focus primarily on data (with the exceptions of stored procedures and some object-relational extensions of relational databases)whereas object-oriented environments by definition integrate data and behavior.

Accepted Answer

A) True 
 B)False

Question 20

________ is a structure that defines relationships between domain classes in the object-oriented model and relations in the relational model.

Accepted Answer

Declarativ

One of the advantages of the call-level API approach is the small amount of code needed to be written.

SQL ________ frameworks provide a set of tools that provide persistence by linking classes to parameters and results of SQL queries.

All of the following are elements of the object-relational impedance mismatch EXCEPT:

The process of using a limited number of database connections that are shared by multiple applications and users is called pooling of database connections.

A performance problem caused by too many select statements generated by an ORM framework is called:

ORM frameworks have the responsibility for generating ________.

What are some of the typical responsibilities of an Object-Relational Mapping Framework?

All of the following are typical responsibilities of the ORM framework EXCEPT:

A persistent solution that hides the underlying storage technology is called:

Transparent persistence is a solution that hides the underlying storage technology.

Persistence defines an object's capability to maintain its between application execution .

In both table per concrete class approaches there is no table representing the ________ superclass.

One advantage of the call-level API approach to providing persistence is:

Serialization is not a realistic method for storing large amounts of structured data.

Object-oriented environments typically do not have an inherent,built-in concept of boundaries between ________.

The conceptual differences between the object-oriented approach to application design and the relational model for database design is called the ________.

The relational database approach is based on the same architectural assumptions as the object-oriented approach.

Storing the state of an object between application execution sessions is called providing ________ to the object.

Relational databases and the processes that are used to design them focus primarily on data (with the exceptions of stored procedures and some object-relational extensions of relational databases)whereas object-oriented environments by definition integrate data and behavior.

________ is a structure that defines relationships between domain classes in the object-oriented model and relations in the relational model.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 14: Using Relational Databases to Provide Object Persistence

One of the advantages of the call-level API approach is the small amount of code needed to be written.

SQL ________ frameworks provide a set of tools that provide persistence by linking classes to parameters and results of SQL queries.

All of the following are elements of the object-relational impedance mismatch EXCEPT:

The process of using a limited number of database connections that are shared by multiple applications and users is called pooling of database connections.

A performance problem caused by too many select statements generated by an ORM framework is called:

ORM frameworks have the responsibility for generating ________.

What are some of the typical responsibilities of an Object-Relational Mapping Framework?

All of the following are typical responsibilities of the ORM framework EXCEPT:

A persistent solution that hides the underlying storage technology is called:

Transparent persistence is a solution that hides the underlying storage technology.

Persistence defines an object's capability to maintain its ________ between application execution ________.

In both table per concrete class approaches there is no table representing the ________ superclass.

One advantage of the call-level API approach to providing persistence is:

Serialization is not a realistic method for storing large amounts of structured data.

Object-oriented environments typically do not have an inherent,built-in concept of boundaries between ________.

The conceptual differences between the object-oriented approach to application design and the relational model for database design is called the ________.

The relational database approach is based on the same architectural assumptions as the object-oriented approach.

Storing the state of an object between application execution sessions is called providing ________ to the object.

Relational databases and the processes that are used to design them focus primarily on data (with the exceptions of stored procedures and some object-relational extensions of relational databases)whereas object-oriented environments by definition integrate data and behavior.

________ is a structure that defines relationships between domain classes in the object-oriented model and relations in the relational model.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Persistence defines an object's capability to maintain its between application execution .