Question 1

ORM frameworks contain tools for managing database performance in the context of ________ applications.

Accepted Answer

The answer of ORM frameworks contain tools for managing database...

Question 2

The core element of Hibernate that defines the relationship between the object-oriented classes and relational files are:

Accepted Answer

A)  flat files. 
B)  relational mapping tables. 
C)  KML files. 
D)  XML files. 
A)  flat files. 
B)  relational mapping tables. 
C)  KML files. 
D)  XML files.

Question 3

All of the following are advantages of the Object-Relational Mapping Frameworks EXCEPT:

Accepted Answer

A)  highest level of persistence transparency. 
B)  full separation of the persistence concern. 
C)  ease of use with legacy databases. 
D)  enable true object-oriented design. 
A)  highest level of persistence transparency. 
B)  full separation of the persistence concern. 
C)  ease of use with legacy databases. 
D)  enable true object-oriented design.

Question 4

In the relational world,each object has its own identity based upon its existence.

Accepted Answer

A) True 
 B)False

Question 5

All of the following are object-relational mapping frameworks EXCEPT:

Accepted Answer

A)  (N)Hibernate. 
B)  EclipseLink 
C)  JPA. 
D)  Topdog. 
A)  (N)Hibernate. 
B)  EclipseLink 
C)  JPA. 
D)  Topdog.

Question 6

Separation of concerns is violated by:

Accepted Answer

A)  including non-persistent code in all classes. 
B)  providing persistence related code in all classes. 
C)  separating code by function. 
D)  none of the above. 
A)  including non-persistent code in all classes. 
B)  providing persistence related code in all classes. 
C)  separating code by function. 
D)  none of the above.

Question 7

An advantage to the call-level API approach is low overhead.

Accepted Answer

A) True 
 B)False

Question 8

An advantage of the SQL query mapping framework is:

Accepted Answer

A)  direct access to all DBMS capabilities provided through SQL. 
B)  SQL code generated automatically. 
C)  database access code is easier to manage than with call-level APIs. 
D)  both A and C. 
A)  direct access to all DBMS capabilities provided through SQL. 
B)  SQL code generated automatically. 
C)  database access code is easier to manage than with call-level APIs. 
D)  both A and C.

Question 9

A mechanism that provides an application program with access to an external service such as a database management system is called a(n):

Accepted Answer

A)  API. 
B)  ADO. 
C)  call-level application program interface. 
D)  WSDL. 
A)  API. 
B)  ADO. 
C)  call-level application program interface. 
D)  WSDL.

Question 10

A single class can provide persistence for two or more tables when using a value type.

Accepted Answer

A) True 
 B)False

Question 11

A ________ application program interface is a mechanism that provides an application program with access to an external service.

Accepted Answer

The answer of A ________ application program interface is a...

Question 12

JDBC is the industry standard call-level API for Java access to SQL databases.

Accepted Answer

A) True 
 B)False

Question 13

ORM frameworks provide a layer of abstraction that separates object-oriented applications from the specific details of a specific database application.

Accepted Answer

A) True 
 B)False

Question 14

In HQL,what does the following statement do?
Select s.sectionRegNbr
From section as s j
Join s.course c
Where c.courseNbr = 'MGMT 390' and s.semester = 'Spring 2008'

Accepted Answer

A)  List section numbers of all sections of MGMT 390 offered in the Spring of 2008 
B)  List all students in MGMT 390 
C)  List all sections of MGMT 390 ever offered 
D)  Return no results 
A)  List section numbers of all sections of MGMT 390 offered in the Spring of 2008 
B)  List all students in MGMT 390 
C)  List all sections of MGMT 390 ever offered 
D)  Return no results

Question 15

SQL query mapping frameworks do not provide transparent persistence.

Accepted Answer

A) True 
 B)False

Question 16

An object's capability to maintain its state between application execution sessions is called ________.

Accepted Answer

The answer of An object's capability to maintain its state...

Question 17

Many ORM frameworks also include a ________.

Accepted Answer

The answer of Many ORM frameworks also include a ________....

Question 18

SQL query mapping frameworks make mapping to legacy database schemas more difficult.

Accepted Answer

A) True 
 B)False

Question 19

Object-oriented environments and relational databases have a very different ________ for accessing persistent data.

Accepted Answer

The answer of Object-oriented environments and relational databases have a...

Question 20

ORM frameworks provide support for transactions and transaction integrity.

Accepted Answer

A) True 
 B)False

ORM frameworks contain tools for managing database performance in the context of ________ applications.

The core element of Hibernate that defines the relationship between the object-oriented classes and relational files are:

All of the following are advantages of the Object-Relational Mapping Frameworks EXCEPT:

In the relational world,each object has its own identity based upon its existence.

All of the following are object-relational mapping frameworks EXCEPT:

Separation of concerns is violated by:

An advantage to the call-level API approach is low overhead.

An advantage of the SQL query mapping framework is:

A mechanism that provides an application program with access to an external service such as a database management system is called a(n):

A single class can provide persistence for two or more tables when using a value type.

A ________ application program interface is a mechanism that provides an application program with access to an external service.

JDBC is the industry standard call-level API for Java access to SQL databases.

ORM frameworks provide a layer of abstraction that separates object-oriented applications from the specific details of a specific database application.

In HQL,what does the following statement do? Select s.sectionRegNbr From section as s j Join s.course c Where c.courseNbr = 'MGMT 390' and s.semester = 'Spring 2008'

SQL query mapping frameworks do not provide transparent persistence.

An object's capability to maintain its state between application execution sessions is called ________.

Many ORM frameworks also include a ________.

SQL query mapping frameworks make mapping to legacy database schemas more difficult.

Object-oriented environments and relational databases have a very different ________ for accessing persistent data.

ORM frameworks provide support for transactions and transaction integrity.

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

ORM frameworks contain tools for managing database performance in the context of ________ applications.

The core element of Hibernate that defines the relationship between the object-oriented classes and relational files are:

All of the following are advantages of the Object-Relational Mapping Frameworks EXCEPT:

In the relational world,each object has its own identity based upon its existence.

All of the following are object-relational mapping frameworks EXCEPT:

Separation of concerns is violated by:

An advantage to the call-level API approach is low overhead.

An advantage of the SQL query mapping framework is:

A mechanism that provides an application program with access to an external service such as a database management system is called a(n):

A single class can provide persistence for two or more tables when using a value type.

A ________ application program interface is a mechanism that provides an application program with access to an external service.

JDBC is the industry standard call-level API for Java access to SQL databases.

ORM frameworks provide a layer of abstraction that separates object-oriented applications from the specific details of a specific database application.

In HQL,what does the following statement do? Select s.sectionRegNbr From section as s j Join s.course c Where c.courseNbr = 'MGMT 390' and s.semester = 'Spring 2008'

SQL query mapping frameworks do not provide transparent persistence.

An object's capability to maintain its state between application execution sessions is called ________.

Many ORM frameworks also include a ________.

SQL query mapping frameworks make mapping to legacy database schemas more difficult.

Object-oriented environments and relational databases have a very different ________ for accessing persistent data.

ORM frameworks provide support for transactions and transaction integrity.

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