Question 1

An object-relational database is used primarily to support multimedia applications.

Accepted Answer

A) True 
 B)False

Question 2

SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.

Accepted Answer

A) True 
 B)False

Question 3

There are many different types of NoSQL data stores including key-value stores, document stores, column-oriented stores, object databases, and RDBMSs.

Accepted Answer

A) True 
 B)False

Question 4

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

Accepted Answer

A)  database 
B)  database management system 
C)  end-user database administrative system 
D)  end-user database management system 
E)  enterprise database management system 
A)  database 
B)  database management system 
C)  end-user database administrative system 
D)  end-user database management system 
E)  enterprise database management system

Question 5

Denormalization is performed before the object storage is optimized.

Accepted Answer

A) True 
 B)False

Question 6

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

Accepted Answer

The key difference is that traditional p

Question 7

If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.

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 8

Explain the object persistence format type known as Object-relational databases.

Accepted Answer

Object-relational database management sy

Question 9

A file that stores core information important to the business is an audit file.

Accepted Answer

A) True 
 B)False

Question 10

Key-value data stores essentially provide a distributed index (primary key) to where a(n) __________________ is stored.

Accepted Answer

A)  BLOB (binary, large object) 
B)  field 
C)  entity 
D)  attribute 
A)  BLOB (binary, large object) 
B)  field 
C)  entity 
D)  attribute

Question 11

A file that stores static values used for reference and validation is a look-up file.

Accepted Answer

A) True 
 B)False

An object-relational database is used primarily to support multimedia applications.

SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.

There are many different types of NoSQL data stores including key-value stores, document stores, column-oriented stores, object databases, and RDBMSs.

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

Denormalization is performed before the object storage is optimized.

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.

Explain the object persistence format type known as Object-relational databases.

A file that stores core information important to the business is an audit file.

Key-value data stores essentially provide a distributed index (primary key) to where a(n) __________________ is stored.

A file that stores static values used for reference and validation is a look-up file.

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

An object-relational database is used primarily to support multimedia applications.

SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.

There are many different types of NoSQL data stores including key-value stores, document stores, column-oriented stores, object databases, and RDBMSs.

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

Denormalization is performed before the object storage is optimized.

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.

Explain the object persistence format type known as Object-relational databases.

A file that stores core information important to the business is an audit file.

Key-value data stores essentially provide a distributed index (primary key) to where a(n) __________________ is stored.

A file that stores static values used for reference and validation is a look-up file.

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