Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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.E) All of the above
F) C) and D)

Question 3

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 loggerE) None of the above
F) B) and D)

Question 4

The Number datatype would be appropriate for a zip code.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False  False

Question 6

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

Accepted Answer

A)   terminated
B)   aborted
C)   completed
D)   deletedE) A) and B)
F) None of the above

Question 7

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.E) C) and D)
F) A) and D)

Question 8

A typical cause of database destruction is a disk crash.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Explain the differences between sequential and indexed file organizations.

Accepted Answer

In sequential file organization, the rec...

Question 11

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 12

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

Accepted Answer

A)   field.
B)   row.
C)   data type.
D)   column.E) B) and D)
F) B) and C)

Question 13

SOX stands for the Sorbet-Oxford Act.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

First, one must choose the storage forma...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Distributing the rows of data into separate files is called:

Accepted Answer

A)   normalization.
B)   horizontal partitioning.
C)   vertical partitioning.
D)   file allocation.E) A) and D)
F) All of the above

Question 18

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.E) B) and C)
F) B) and D)

Question 19

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

Accepted Answer

A)   Horizontal
B)   Crossways
C)   Vertical
D)   FinalE) C) and D)
F) A) and C)

Question 20

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.E) B) and D)
F) C) and D)

Exam 8: Physical Database Design and Database Infrastructure

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

Correct Answer
verified

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

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 query processor always knows the best way to process a query.

Correct Answer
verified
False

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

Correct Answer
verified

Sensitivity testing involves:

Correct Answer
verified

A typical cause of database destruction is a disk crash.

Correct Answer
verified

What is clustering?

Explain the differences between sequential and indexed file organizations.

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

How are missing values generally handled in database management systems?

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

Correct Answer
verified

SOX stands for the Sorbet-Oxford Act.

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

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

The preferred method of fixing an aborted transaction is:

Correct Answer
verified

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

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

Exam 8: Physical Database Design and Database Infrastructure

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

Correct AnswerverifiedShow Answer

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

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 query processor always knows the best way to process a query.

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

Sensitivity testing involves:

Correct AnswerverifiedShow Answer

A typical cause of database destruction is a disk crash.

Correct AnswerverifiedShow Answer

What is clustering?

Explain the differences between sequential and indexed file organizations.

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

How are missing values generally handled in database management systems?

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

Correct AnswerverifiedShow Answer

SOX stands for the Sorbet-Oxford Act.

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

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

The preferred method of fixing an aborted transaction is:

Correct AnswerverifiedShow Answer

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified