Question 1

Which of the following is NOT a characteristic of current object-relational databases?

Accepted Answer

A)  storage of objects in the relational table structure 
B)  good support for typical data management operations 
C)  SQL support 
D)  support for inheritance 
E)  all of the above are characteristics of object-relational databases 
A)  storage of objects in the relational table structure 
B)  good support for typical data management operations 
C)  SQL support 
D)  support for inheritance 
E)  all of the above are characteristics of object-relational databases

Question 2

Why would an analyst both normalize and denormalize the design of the data management layer?

Accepted Answer

Normalization is performed to assure tha

Question 3

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

Accepted Answer

A)  One data access and manipulation class for each concrete problem domain class 
B)  Two data access and manipulation classes for each concrete problem domain class 
C)  N data access and manipulation classes for each concrete problem domain class, where N is the number of methods in the problem domain class 
D)  N data access and manipulation classes for each concrete problem domain class, where N is the number of subclasses of the problem domain class 
E)  None of the above 
A)  One data access and manipulation class for each concrete problem domain class 
B)  Two data access and manipulation classes for each concrete problem domain class 
C)  N data access and manipulation classes for each concrete problem domain class, where N is the number of methods in the problem domain class 
D)  N data access and manipulation classes for each concrete problem domain class, where N is the number of subclasses of the problem domain class 
E)  None of the above

Question 4

In terms of storage space, the most efficient tables in a relational database have redundant data and many null values.

Accepted Answer

A) True 
 B)False

Question 5

A master file holds information temporarily so that it can be used to update other master files.

Accepted Answer

A) True 
 B)False

Question 6

If the data model does not have any repeating fields it is in _____.

Accepted Answer

A)  base normal form 
B)  first normal form 
C)  non-normal form 
D)  second normal form 
E)  third normal form 
A)  base normal form 
B)  first normal form 
C)  non-normal form 
D)  second normal form 
E)  third normal form

Question 7

The most efficient tables in a relational database in terms of storage space have redundant data and few null values.

Accepted Answer

A) True 
 B)False

Question 8

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

Accepted Answer

One situation is in the case of look-up

Question 9

The type of database that is most capable of supporting complex data types is _____.

Accepted Answer

A)  sequential files 
B)  relational DBMS 
C)  object-oriented DBMS 
D)  object-relational DBMS 
E)  random access files 
A)  sequential files 
B)  relational DBMS 
C)  object-oriented DBMS 
D)  object-relational DBMS 
E)  random access files

Question 10

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

Accepted Answer

A)  hierarchical integrity 
B)  primary integrity 
C)  table integrity 
D)  referential unity 
E)  referential integrity 
A)  hierarchical integrity 
B)  primary integrity 
C)  table integrity 
D)  referential unity 
E)  referential integrity

Question 11

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

Accepted Answer

A)  attribute 
B)  row 
C)  table 
D)  relationship 
E)  unique identifier 
A)  attribute 
B)  row 
C)  table 
D)  relationship 
E)  unique identifier

Question 12

Explain the object persistence format type known as Relational databases.

Accepted Answer

Relational database management systems (

Question 13

A(n) _____ is basically an electronic list of information that is stored on a disk.

Accepted Answer

A)  sequential access file 
B)  unordered sequential access file 
C)  ordered sequential access file 
D)  random access file 
E)  transaction file 
A)  sequential access file 
B)  unordered sequential access file 
C)  ordered sequential access file 
D)  random access file 
E)  transaction file

Question 14

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values because the presence of these suggest that space is being wasted, and more data to store means higher data storage hardware costs.

Accepted Answer

A) True 
 B)False

Question 15

An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later.

Accepted Answer

A) True 
 B)False

Question 16

The normalization process is performed primarily to increase the database's storage efficiency.

Accepted Answer

A) True 
 B)False

Question 17

Lauren and her team have been hired to create a transaction system for Mike's Motorcycles. Mike's is a medium size shop with 10 employees that sells motorcycle parts and does repair on motorcycles, lawn mowers, and other small engine systems (boats, dune buggies, tractors, etc.) As part of Lauren's team, you need to recommend relational database management system.

Accepted Answer

A) True 
 B)False

Question 18

Explain the term Indexing.

Accepted Answer

An index is a mini-table that contains v

Question 19

Most NoSQL data stores were created to address problems associated with storing large amounts of distributed data in __________.

Accepted Answer

A)  SQL Server 
B)  ORDBMSs 
C)  OODBMSs 
D)  RDDBMSs 
E)  MySQL 
A)  SQL Server 
B)  ORDBMSs 
C)  OODBMSs 
D)  RDDBMSs 
E)  MySQL

Question 20

An image file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.

Accepted Answer

A) True 
 B)False

Which of the following is NOT a characteristic of current object-relational databases?

Why would an analyst both normalize and denormalize the design of the data management layer?

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

In terms of storage space, the most efficient tables in a relational database have redundant data and many null values.

A master file holds information temporarily so that it can be used to update other master files.

If the data model does not have any repeating fields it is in _____.

The most efficient tables in a relational database in terms of storage space have redundant data and few null values.

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

The type of database that is most capable of supporting complex data types is _____.

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

Explain the object persistence format type known as Relational databases.

A(n) _____ is basically an electronic list of information that is stored on a disk.

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values because the presence of these suggest that space is being wasted, and more data to store means higher data storage hardware costs.

An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later.

The normalization process is performed primarily to increase the database's storage efficiency.

Explain the term Indexing.

Most NoSQL data stores were created to address problems associated with storing large amounts of distributed data in __________.

An image file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.

Introduction to Systems Analysis and Design

Project Management

Requirements Determination

Business Process and Functional Modeling

Structural Modeling

Behavioral Modeling

Moving on to Design

Class and Method Design

Human Computer Interaction Layer Design

Physical Architecture Layer Design

Construction

Installation and Operations

Filters

Exam 9: Data Management Layer Design

Which of the following is NOT a characteristic of current object-relational databases?

Why would an analyst both normalize and denormalize the design of the data management layer?

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

In terms of storage space, the most efficient tables in a relational database have redundant data and many null values.

A master file holds information temporarily so that it can be used to update other master files.

If the data model does not have any repeating fields it is in _____.

The most efficient tables in a relational database in terms of storage space have redundant data and few null values.

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

The type of database that is most capable of supporting complex data types is _____.

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

Explain the object persistence format type known as Relational databases.

A(n) _____ is basically an electronic list of information that is stored on a disk.

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values because the presence of these suggest that space is being wasted, and more data to store means higher data storage hardware costs.

An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later.

The normalization process is performed primarily to increase the database's storage efficiency.

Explain the term Indexing.

Most NoSQL data stores were created to address problems associated with storing large amounts of distributed data in __________.

An image file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.

Introduction to Systems Analysis and Design

Project Management

Requirements Determination

Business Process and Functional Modeling

Structural Modeling

Behavioral Modeling

Moving on to Design

Class and Method Design

Human Computer Interaction Layer Design

Physical Architecture Layer Design

Construction

Installation and Operations

Filters