Question 1

A file organization is a named portion of primary memory.

Accepted Answer

A) True 
 B)False

Question 2

A factor to consider when choosing a file organization is:

Accepted Answer

A)  inefficient data retrieval. 
B)  DDL. 
C)  efficient storage. 
D)  DML. 
A)  inefficient data retrieval. 
B)  DDL. 
C)  efficient storage. 
D)  DML.

Question 3

A range control limits the set of permissible values that a field may assume.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

First, one must choose the storage forma

Question 5

Keeping the zip code with the city and state in a table is a typical form of denormalization.

Accepted Answer

A) True 
 B)False

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

Denormalization almost always leads to more storage space for raw data.

Accepted Answer

A) True 
 B)False

Question 8

A method for handling missing data is to:

Accepted Answer

A)  substitute with random numbers for the missing data. 
B)  track missing data with special reports. 
C)  perform insensitivity testing. 
D)  delete the associated row. 
A)  substitute with random numbers for the missing data. 
B)  track missing data with special reports. 
C)  perform insensitivity testing. 
D)  delete the associated row.

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

A key decision in the physical design process is:

Accepted Answer

A)  ignoring the size of the database. 
B)  selecting structures. 
C)  deciding on the monitor. 
D)  deciding the e-r diagrams. 
A)  ignoring the size of the database. 
B)  selecting structures. 
C)  deciding on the monitor. 
D)  deciding the e-r diagrams.

Question 12

Indexes are most useful on small, clustered files.

Accepted Answer

A) True 
 B)False

Question 13

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

Accepted Answer

A) True 
 B)False

Question 14

A(n) ________ is a routine that converts a primary key value into a relative record number.

Accepted Answer

A)  record index calculator 
B)  index pointer program 
C)  hashing algorithm 
D)  pointing algorithm 
A)  record index calculator 
B)  index pointer program 
C)  hashing algorithm 
D)  pointing algorithm

Question 15

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Discuss coding techniques and how they could be used.

Accepted Answer

Coding techniques are used in cases when

Question 18

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 19

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

Accepted Answer

A) True 
 B)False

Question 20

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

Accepted Answer

A) True 
 B)False

A file organization is a named portion of primary memory.

A factor to consider when choosing a file organization is:

A range control limits the set of permissible values that a field may assume.

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

Keeping the zip code with the city and state in a table is a typical form of denormalization.

All of the following are common denormalization opportunities EXCEPT:

Denormalization almost always leads to more storage space for raw data.

A method for handling missing data is to:

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

A key decision in the physical design process is:

Indexes are most useful on small, clustered files.

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

A(n) ________ is a routine that converts a primary key value into a relative record number.

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

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

Discuss coding techniques and how they could be used.

Distributing the rows of data into separate files is called:

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

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

A file organization is a named portion of primary memory.

A factor to consider when choosing a file organization is:

A range control limits the set of permissible values that a field may assume.

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

Keeping the zip code with the city and state in a table is a typical form of denormalization.

All of the following are common denormalization opportunities EXCEPT:

Denormalization almost always leads to more storage space for raw data.

A method for handling missing data is to:

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

A key decision in the physical design process is:

Indexes are most useful on small, clustered files.

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

A(n) ________ is a routine that converts a primary key value into a relative record number.

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

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

Discuss coding techniques and how they could be used.

Distributing the rows of data into separate files is called:

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

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