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

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

Accepted Answer

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

Question 3

Explain the differences between sequential and indexed file organizations.

Accepted Answer

In sequential file organization, the rec...

Question 4

A typical cause of database destruction is a disk crash.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False  False

Question 7

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.

Question 8

SOX stands for the Sorbet-Oxford Act.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Distributing the rows of data into separate files is called:

Accepted Answer

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

Question 11

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.

Question 12

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 13

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.

Question 14

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.

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

The Number datatype would be appropriate for a zip code.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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 20

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

Accepted Answer

First, one must choose the storage forma...

Exam 8: Physical Database Design and Database Infrastructure

How are missing values generally handled in database management systems?

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

Correct Answer
verified

Explain the differences between sequential and indexed file organizations.

Correct Answer
verified
In sequential file organization, the rec...
View Answer

A typical cause of database destruction is a disk crash.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
False

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:

Correct Answer
verified

SOX stands for the Sorbet-Oxford Act.

Correct Answer
verified

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

Correct Answer
verified

Distributing the rows of data into separate files is called:

Correct Answer
verified

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:

Correct Answer
verified

What is clustering?

Sensitivity testing involves:

Correct Answer
verified

The preferred method of fixing an aborted transaction is:

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The Number datatype would be appropriate for a zip code.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified
First, one must choose the storage forma...
View Answer

Exam 8: Physical Database Design and Database Infrastructure

How are missing values generally handled in database management systems?

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

Correct AnswerverifiedShow Answer

Explain the differences between sequential and indexed file organizations.

Correct AnswerverifiedIn sequential file organization, the rec...View AnswerShow Answer

A typical cause of database destruction is a disk crash.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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:

Correct AnswerverifiedShow Answer

SOX stands for the Sorbet-Oxford Act.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Distributing the rows of data into separate files is called:

Correct AnswerverifiedShow Answer

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:

Correct AnswerverifiedShow Answer

What is clustering?

Sensitivity testing involves:

Correct AnswerverifiedShow Answer

The preferred method of fixing an aborted transaction is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Number datatype would be appropriate for a zip code.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFirst, one must choose the storage forma...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified
In sequential file organization, the rec...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
First, one must choose the storage forma...
View Answer