Question 1

How are missing values generally handled in database management systems?

Accepted Answer

When dealing with missing data, there are many options. Two integrity controls (default value and null control) will handle this problem. One also could substitute an estimate for the missing value which would then be stored in place of the missing value (and marked as an estimate). Another possible method is to use triggers to track missing values and create a log which can be viewed later. One other method is to perform sensitivity testing, which will tell us whether having missing data greatly impacts results. If results are not impacted, then the missing values are ignored.

Question 2

The query processor always knows the best way to process a query.

Accepted Answer

A) True 
 B)False  False

Question 3

What is clustering?

Accepted Answer

Clustering is a technique used in some database management systems (such as Oracle) to allow adjacent secondary memory space to contain rows from several tables. A cluster is defined by the tables used as well as the column or columns used for clustering. To create a cluster in Oracle, for example, we would create a cluster first with a create cluster command and then reference the cluster when we create each individual table.

Question 4

SOX stands for the Sorbet-Oxford Act.

Accepted Answer

A) True 
 B)False

Question 5

The smallest unit of application data recognized by system software is a:

Accepted Answer

A)  field. 
B)  row. 
C)  data type. 
D)  column. 
A)  field. 
B)  row. 
C)  data type. 
D)  column.

Question 6

The preferred method of fixing an aborted transaction is:

Accepted Answer

A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction. 
A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction.

Question 7

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

Accepted Answer

A)  hashed file organization. 
B)  hash key. 
C)  multi-indexed file organization. 
D)  hash index table. 
A)  hashed file organization. 
B)  hash key. 
C)  multi-indexed file organization. 
D)  hash index table.

Question 8

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager.

Accepted Answer

A) True 
 B)False

Question 9

Distributing the rows of data into separate files is called:

Accepted Answer

A)  normalization. 
B)  horizontal partitioning. 
C)  vertical partitioning. 
D)  file allocation. 
A)  normalization. 
B)  horizontal partitioning. 
C)  vertical partitioning. 
D)  file allocation.

Question 10

A cloud computing approach in which the service consists of infrastructure resources and additional tools that enable application and solution data management solution developers to reach a high level of productivity is called:

Accepted Answer

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

Question 11

Discuss the critical decisions that must be made during physical database design.

Accepted Answer

First, one must choose the storage forma

Question 12

Explain the differences between sequential and indexed file organizations.

Accepted Answer

In sequential file organization, the rec

Question 13

The logical database design always forms the best foundation for grouping attributes in the physical design.

Accepted Answer

A) True 
 B)False

Question 14

Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.

Accepted Answer

A) True 
 B)False

Question 15

A typical cause of database destruction is a disk crash.

Accepted Answer

A) True 
 B)False

Question 16

Sensitivity testing involves:

Accepted Answer

A)  checking to see if your teeth hurt when you brush. 
B)  seeing how accurate data are. 
C)  checking to see if missing data will greatly impact results. 
D)  deleting the associated row. 
A)  checking to see if your teeth hurt when you brush. 
B)  seeing how accurate data are. 
C)  checking to see if missing data will greatly impact results. 
D)  deleting the associated row.

Question 17

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

Accepted Answer

A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger 
A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger

Question 18

________ partitioning distributes the columns of a table into several separate physical records.

Accepted Answer

A)  Horizontal 
B)  Crossways 
C)  Vertical 
D)  Final 
A)  Horizontal 
B)  Crossways 
C)  Vertical 
D)  Final

Question 19

A transaction that terminates abnormally is called a(n) ________ transaction.

Accepted Answer

A)  terminated 
B)  aborted 
C)  completed 
D)  deleted 
A)  terminated 
B)  aborted 
C)  completed 
D)  deleted

Question 20

The Number datatype would be appropriate for a zip code.

Accepted Answer

A) True 
 B)False

How are missing values generally handled in database management systems?

The query processor always knows the best way to process a query.

What is clustering?

SOX stands for the Sorbet-Oxford Act.

The smallest unit of application data recognized by system software is a:

The preferred method of fixing an aborted transaction is:

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager.

Distributing the rows of data into separate files is called:

A cloud computing approach in which the service consists of infrastructure resources and additional tools that enable application and solution data management solution developers to reach a high level of productivity is called:

Discuss the critical decisions that must be made during physical database design.

Explain the differences between sequential and indexed file organizations.

The logical database design always forms the best foundation for grouping attributes in the physical design.

Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.

A typical cause of database destruction is a disk crash.

Sensitivity testing involves:

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

________ partitioning distributes the columns of a table into several separate physical records.

A transaction that terminates abnormally is called a(n) ________ transaction.

The Number datatype would be appropriate for a zip code.

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

How are missing values generally handled in database management systems?

The query processor always knows the best way to process a query.

What is clustering?

SOX stands for the Sorbet-Oxford Act.

The smallest unit of application data recognized by system software is a:

The preferred method of fixing an aborted transaction is:

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager.

Distributing the rows of data into separate files is called:

A cloud computing approach in which the service consists of infrastructure resources and additional tools that enable application and solution data management solution developers to reach a high level of productivity is called:

Discuss the critical decisions that must be made during physical database design.

Explain the differences between sequential and indexed file organizations.

The logical database design always forms the best foundation for grouping attributes in the physical design.

Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.

A typical cause of database destruction is a disk crash.

Sensitivity testing involves:

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

________ partitioning distributes the columns of a table into several separate physical records.

A transaction that terminates abnormally is called a(n) ________ transaction.

The Number datatype would be appropriate for a zip code.

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