Question 1

When incorrect data have been introduced, the database is best recovered by:

Accepted Answer

A)  starting with a new ERD. 
B)  formatting server. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  reloading RDMS software. 
A)  starting with a new ERD. 
B)  formatting server. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  reloading RDMS software.

Question 2

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

Accepted Answer

A)  checkpoint facility. 
B)  backup facility. 
C)  recovery manager. 
D)  database change log. 
A)  checkpoint facility. 
B)  backup facility. 
C)  recovery manager. 
D)  database change log.

Question 3

A join index is a combination of two or more indexes.

Accepted Answer

A) True 
 B)False

Question 4

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

Accepted Answer

A) True 
 B)False

Question 5

Horizontal partitioning makes sense:

Accepted Answer

A)  when different categories of a table's rows are processed separately. 
B)  when less security is needed. 
C)  when partitions must be organized the same. 
D)  when only one category is allowed. 
A)  when different categories of a table's rows are processed separately. 
B)  when less security is needed. 
C)  when partitions must be organized the same. 
D)  when only one category is allowed.

Question 6

All of the following are common denormalization opportunities EXCEPT:

Accepted Answer

A)  two entities with a one-to-one relationship. 
B)  a one-to-many relationship. 
C)  a many-to-many relationship with nonkey attributes. 
D)  reference data. 
A)  two entities with a one-to-one relationship. 
B)  a one-to-many relationship. 
C)  a many-to-many relationship with nonkey attributes. 
D)  reference data.

Question 7

All of the following are characteristics of cloud technologies EXCEPT:

Accepted Answer

A)  unlimited bandwidth. 
B)  on-demand self-service IT capabilities. 
C)  broad network access. 
D)  rapid elasticity. 
A)  unlimited bandwidth. 
B)  on-demand self-service IT capabilities. 
C)  broad network access. 
D)  rapid elasticity.

Question 8

Discuss how data integrity can be controlled.

Accepted Answer

In many database management systems, dat

Question 9

What threats to data security must be addressed in a comprehensive data security plan?

Accepted Answer

A comprehensive data security plan must

Question 10

In which type of file is multiple key retrieval not possible?

Accepted Answer

A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered 
A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered

Question 11

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

Accepted Answer

A) True 
 B)False

Question 12

Indexes are most useful on small, clustered files.

Accepted Answer

A) True 
 B)False

Question 13

A data management platform service is called:

Accepted Answer

A)  Infrastructure-as-a-service. 
B)  Platform-as-a-service. 
C)  Software-as-a-service. 
D)  Database-as-a-service. 
A)  Infrastructure-as-a-service. 
B)  Platform-as-a-service. 
C)  Software-as-a-service. 
D)  Database-as-a-service.

Question 14

Discuss the rationale behind data volume and usage analysis.

Accepted Answer

Data volume and frequency of use statist

Question 15

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:

Accepted Answer

A)  explain plan. 
B)  show optimization. 
C)  explain query. 
D)  analyze query. 
A)  explain plan. 
B)  show optimization. 
C)  explain query. 
D)  analyze query.

Question 16

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.

Accepted Answer

A) True 
 B)False

Question 17

The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a principal type of authorization table?

Accepted Answer

A)  Subject 
B)  Transaction 
C)  View 
D)  Index 
A)  Subject 
B)  Transaction 
C)  View 
D)  Index

Question 19

In which data model would a code table appear?

Accepted Answer

A)  Conceptual 
B)  Logical 
C)  Physical 
D)  Data layout 
A)  Conceptual 
B)  Logical 
C)  Physical 
D)  Data layout

Question 20

One method to handle missing values is to substitute an exact value.

Accepted Answer

A) True 
 B)False

When incorrect data have been introduced, the database is best recovered by:

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

A join index is a combination of two or more indexes.

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

Horizontal partitioning makes sense:

All of the following are common denormalization opportunities EXCEPT:

All of the following are characteristics of cloud technologies EXCEPT:

Discuss how data integrity can be controlled.

What threats to data security must be addressed in a comprehensive data security plan?

In which type of file is multiple key retrieval not possible?

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

Indexes are most useful on small, clustered files.

A data management platform service is called:

Discuss the rationale behind data volume and usage analysis.

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.

The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.

Which of the following is a principal type of authorization table?

In which data model would a code table appear?

One method to handle missing values is to substitute an exact value.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 8: Physical Database Design and Database Infrastructure

When incorrect data have been introduced, the database is best recovered by:

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

A join index is a combination of two or more indexes.

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

Horizontal partitioning makes sense:

All of the following are common denormalization opportunities EXCEPT:

All of the following are characteristics of cloud technologies EXCEPT:

Discuss how data integrity can be controlled.

What threats to data security must be addressed in a comprehensive data security plan?

In which type of file is multiple key retrieval not possible?

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

Indexes are most useful on small, clustered files.

A data management platform service is called:

Discuss the rationale behind data volume and usage analysis.

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.

The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.

Which of the following is a principal type of authorization table?

In which data model would a code table appear?

One method to handle missing values is to substitute an exact value.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters