Question 1

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

Accepted Answer

A) True 
 B)False  False

Question 2

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

Accepted Answer

A)  physical pointer 
B)  retrieval program 
C)  file organization 
D)  update program 
A)  physical pointer 
B)  retrieval program 
C)  file organization 
D)  update program C

Question 3

Which type of file is easiest to update?

Accepted Answer

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

Question 4

Security is one advantage of partitioning.

Accepted Answer

A) True 
 B)False

Question 5

The Number datatype would be appropriate for a zip code.

Accepted Answer

A) True 
 B)False

Question 6

An appropriate datatype for adding a sound clip would be:

Accepted Answer

A)  VarChar. 
B)  Char. 
C)  Blob. 
D)  Date. 
A)  VarChar. 
B)  Char. 
C)  Blob. 
D)  Date.

Question 7

Vertical partitioning means distributing the columns of a table into several separate physical records.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is an objective of selecting a data type?

Accepted Answer

A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity 
A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity

Question 9

When would you use horizontal partitioning, and when would you use vertical partitioning?

Accepted Answer

Horizontal partitioning is best used whe

Question 10

Hash partitioning spreads data evenly across partitions independent of any partition key value.

Accepted Answer

A) True 
 B)False

Question 11

Discuss three possible opportunities for denormalization.

Accepted Answer

There are several possible situations wh

Question 12

Which type of file is most efficient with storage space?

Accepted Answer

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

Question 13

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

Accepted Answer

A)  secondary key. 
B)  index. 
C)  composite key. 
D)  linked key. 
A)  secondary key. 
B)  index. 
C)  composite key. 
D)  linked key.

Question 14

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space.

Accepted Answer

A) True 
 B)False

Question 15

Discuss why physical database design is a foundation for compliance with regulations on financial reporting.

Accepted Answer

Careful physical design enables an organ

Question 16

Discuss how data integrity can be controlled.

Accepted Answer

In many database management systems, dat

Question 17

An advantage of partitioning is:

Accepted Answer

A)  efficiency. 
B)  remote optimization. 
C)  extra space and update time. 
D)  increase redundancy. 
A)  efficiency. 
B)  remote optimization. 
C)  extra space and update time. 
D)  increase redundancy.

Question 18

Along with table scans, other elements of a query can be processed in parallel.

Accepted Answer

A) True 
 B)False

Question 19

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 20

An integrity control supported by a DBMS is:

Accepted Answer

A)  substitute estimates. 
B)  security. 
C)  range control. 
D)  GUI guards. 
A)  substitute estimates. 
B)  security. 
C)  range control. 
D)  GUI guards.

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

Which type of file is easiest to update?

Security is one advantage of partitioning.

The Number datatype would be appropriate for a zip code.

An appropriate datatype for adding a sound clip would be:

Vertical partitioning means distributing the columns of a table into several separate physical records.

Which of the following is an objective of selecting a data type?

When would you use horizontal partitioning, and when would you use vertical partitioning?

Hash partitioning spreads data evenly across partitions independent of any partition key value.

Discuss three possible opportunities for denormalization.

Which type of file is most efficient with storage space?

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space.

Discuss why physical database design is a foundation for compliance with regulations on financial reporting.

Discuss how data integrity can be controlled.

An advantage of partitioning is:

Along with table scans, other elements of a query can be processed in parallel.

Sensitivity testing involves:

An integrity control supported by a DBMS is:

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

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 5: Physical Database Design and Performance

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

Which type of file is easiest to update?

Security is one advantage of partitioning.

The Number datatype would be appropriate for a zip code.

An appropriate datatype for adding a sound clip would be:

Vertical partitioning means distributing the columns of a table into several separate physical records.

Which of the following is an objective of selecting a data type?

When would you use horizontal partitioning, and when would you use vertical partitioning?

Hash partitioning spreads data evenly across partitions independent of any partition key value.

Discuss three possible opportunities for denormalization.

Which type of file is most efficient with storage space?

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space.

Discuss why physical database design is a foundation for compliance with regulations on financial reporting.

Discuss how data integrity can be controlled.

An advantage of partitioning is:

Along with table scans, other elements of a query can be processed in parallel.

Sensitivity testing involves:

An integrity control supported by a DBMS is:

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

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters