Deck 14: Using Relational Databases to Provide Object Persistence

Question 1

Object-oriented languages provide a built-in mechanism for storing a persistent state of an object.This is called:

A) serialization.
B) persistence.
C) integrity constraints.
D) none of the above.

Answer 1

A

Question 2

A structure that defines the relationships between domain classes in the object-oriented model and relations in a relational model is called:

A) domain mapping schema.
B) domain logistic class hierarchy.
C) relational-domain model.
D) declarative mapping schema.

Answer 2

D

Question 3

A technique to define structural relationships between object-oriented and relational representations of data is called:

A) object-oriented relational database management systems.
B) persistence.
C) object-relational mapping.
D) relation object mapping.

Answer 3

C

Question 4

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

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

Question 5

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

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 6

Results from a call-level application program interface query are returned as:

A) a set of rows consisting of untyped columns.
B) an SQL query.
C) a cursor.
D) a record set.

Question 7

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

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

Question 8

An advantage of the SQL query mapping framework is:

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(n)________ is a method that provides other objects with access to the state of an object.

A) accessor method
B) attribute method
C) concrete method
D) abstract method

Question 10

The property of an object that separates it from other objects based on its existence is called:

A) object orientation.
B) object persistence.
C) object identity.
D) matrix of objects.

Question 11

All of the following are disadvantages of using the call-level API approach to providing persistence EXCEPT:

A) little reuse of code.
B) moderate to high overhead.
C) need to write a lot of detailed code.
D) proliferation of code related to database connectivity.

Question 12

Micrsoft's ________ query is a tool for integrating data access directly into object-oriented environments.

A) visual basic
B) visual c++
C) Language Integrated
D) visual studio

Question 13

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

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

Question 14

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

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

Question 15

The conceptual gap between the object-oriented approach to application design and the relational model is often labeled as a ________.

A) mismatch
B) schism
C) void
D) goal

Question 16

________ are a category of tools which use relational databases to provide object persistence by linking classes to parameters and results of SQL queries.

A) Query mapping parameters
B) SQL query mapping frameworks
C) Object-relational mapping frameworks
D) )Net

Question 17

________ has been an industry standard for a call-level application program interface with which Java programs can access SQL databases.

A) ODBC
B) JDBC
C) XML
D) SOAP

Question 18

Object-oriented databases never took off because of:

A) lack of organizational inertia
B) lack of powerful query capabilities found in relational databases
C) a less sophisticated mathematical model
D) all of the above.

Question 19

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

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

Question 20

The identity of the ________ is dealt with differently in the object-oriented and relational worlds.

A) attributes
B) entities
C) objects
D) core Elements

Question 21

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

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

Question 22

Serialization is a built-in mechanism for storing a persistent state of an object in object-oriented languages.

Question 23

Object-relational mapping defines structural relationships between object-oriented and relational representations of data.

Question 24

The difference between the object-oriented world and the relational world is called integrity-object mismatch.

Question 25

A disadvantage of Object-Relational Mapping Frameworks is:

A) more overhead than with call-level APIs.
B) difficulty with legacy databases.
C) true object-oriented design.
D) both A and B.

Question 26

All of the following are disadvantages of the SQL query mapping framework EXCEPT:

A) more overhead than with call-level APIs.
B) does not provide a transparent persistence.
C) database access code more difficult to manage than with call-level APIs.
D) SQL code not generated automatically.

Question 27

A class specification for objects that exist for storing the value of a property of another object is called a:

A) value class.
B) sub-type.
C) value type.
D) literal type.

Question 28

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

Question 29

The identity of the core elements (objects/entity instances)is dealt with differently in the object-oriented and relational worlds.

Question 30

All of the following are ways to represent an inheritance structure in a database EXCEPT:

A) table per concrete class with implicit polymorphism.
B) table per concrete class with unions.
C) table per abstract class with joins.
D) table per class hierarchy.

Question 31

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

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 32

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

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

Question 33

Separation of concerns is violated by:

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 34

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

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

Question 35

Serialization's performance is scalable and provides sufficient response time.

Question 36

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'

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 37

A model for specifying when and how an ORM framework retrieves persistent objects to the run-time memory during a navigation process is called:

A) fetching strategy.
B) navigation strategy.
C) object permanence.
D) class navigation.

Question 38

An entity class is:

A) a class that represents a real-world entity.
B) an instance of an entity.
C) a relationship between two classes.
D) none of the above.

Question 39

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

Question 40

The conceptual gap between the object-oriented approach to application design and the relational model for database design and implementation is often labeled as a perfect match.

Question 41

Comprehensive object-relational mapping frameworks hide the relational data access methods from the object-oriented applications and provide an entirely translucent persistence layer.

Question 42

Lack of automatic SQL code generation is a disadvantage in the call-level API approach.

Question 43

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

Question 44

Closed database connectivity is another call-level API.

Question 45

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

Question 46

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

Question 47

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

Question 48

Object-oriented environments and relational environments have the same navigational model for accessing persistent data.

Question 49

SQL query mapping frameworks do not provide transparent persistence.

Question 50

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

Question 51

IBATIS is an example of an SQL query mapping framework.

Question 52

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

Question 53

Object-relational mapping frameworks require less overhead than call-level APIs and query mapping frameworks.

Question 54

SQL Query Mapping Frameworks are an elegant compromise that hide some of the complexity of JDBC and ADO.Net yet give developers full access to SQL.

Question 55

Hibernate is configured using an HTML file.

Question 56

In the object-oriented world,a typical way to access a data item is to call the accessor method associated with a specific attribute.

Question 57

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

Question 58

A structure that defines the relationship between domain classes in the object-oriented model and relations in the relational model is called the independent mapping schema.

Question 59

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

Question 60

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.

Question 61

ORM frameworks often include a custom query language.An example of this is HQL.

Question 62

ORM frameworks include tools for managing database performance in the context of object-oriented applications.

Question 63

________ refers to the process of writing an object into a storage medium or communication channel as a data stream.

Question 64

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

Question 65

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

Question 66

Object-relational mapping (ORM)defines relationships between object-oriented and ________ data.

Question 67

In HQL,an implicit association join allows us to use object-oriented navigation in the queries.

Question 68

Serialization's performance is simply not ________ for purposes that require fast and constant response times.

Question 69

ORM frameworks provide support for transactions and transaction integrity.

Question 70

Object identity refers to the property of a(n)________ that separating it from other ________ based upon its existence.

Question 71

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

Question 72

Pulling strategies determine when and how a framework retrieves persistent objects to the run-time memory.

Question 73

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

Question 74

ORM frameworks do not generate SQL code.

Question 75

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

Question 76

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

Question 77

A typical way to access a data item in the object-oriented world is through the ________.

Question 78

An inheritance structure can be represented in at least four ways in a database.

Question 79

In most cases,the relationship between a class in the object-oriented world and a relational table is one-to-one.

Question 80

HQL provides three different ways of expressing joins.