Question 1

________ is often used to decide whether or not missing data can be ignored.

Accepted Answer

The answer of ________ is often used to decide whether...

Question 2

A(n)________ is defined by the tables and column of columns by which the tables are joined.

Accepted Answer

The answer of A(n)________ is defined by the tables and...

Question 3

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 4

A method to allow adjacent secondary memory space to contain rows from several tables is called:

Accepted Answer

A)  cluttering. 
B)  clustering. 
C)  concatenating. 
D)  compiling. 
A)  cluttering. 
B)  clustering. 
C)  concatenating. 
D)  compiling.

Question 5

Discuss the advantages and disadvantages of partitioning.

Accepted Answer

Partitioning data has several advantages

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Horizontal partitioning is very different from creating a supertype/subtype relationship.

Accepted Answer

A) True 
 B)False

Question 9

How are missing values generally handled in database management systems?

Accepted Answer

When dealing with missing data,there are

Question 10

A hashing algorithm is a routine that converts a primary key value into a relative record number.

Accepted Answer

A) True 
 B)False

Question 11

Horizontal partitioning makes sense:

Accepted Answer

A)  when different categories of a table's rows are processed separately. 
B)  when less security is needed. 
C)  when partitions must be organized the same. 
D)  when all of the above are true. 
A)  when different categories of a table's rows are processed separately. 
B)  when less security is needed. 
C)  when partitions must be organized the same. 
D)  when all of the above are true.

Question 12

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.

Question 13

In most cases the goal of ________ dominates the design process.

Accepted Answer

A)  efficient data processing 
B)  security 
C)  quick pointer updates 
D)  shorter design times 
A)  efficient data processing 
B)  security 
C)  quick pointer updates 
D)  shorter design times

Question 14

A(n)________ is a field of data used to locate a related field or record.

Accepted Answer

A)  key 
B)  index 
C)  lock 
D)  pointer 
A)  key 
B)  index 
C)  lock 
D)  pointer

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A contiguous section of disk storage space is called a(n):

Accepted Answer

A)  track. 
B)  sector. 
C)  extent. 
D)  tablespace. 
A)  track. 
B)  sector. 
C)  extent. 
D)  tablespace.

Question 17

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

Accepted Answer

Horizontal partitioning is best used whe

Question 18

The smallest unit of named application data is a record.

Accepted Answer

A) True 
 B)False

Question 19

Denormalization is the process of transforming normalized relations into ________ physical record specifications.

Accepted Answer

The answer of Denormalization is the process of transforming normalized...

Question 20

Parallel query processing speed is not significantly different from running queries in a non-parallel mode.

Accepted Answer

A) True 
 B)False

________ is often used to decide whether or not missing data can be ignored.

A(n)________ is defined by the tables and column of columns by which the tables are joined.

All of the following are common denormalization opportunities EXCEPT:

A method to allow adjacent secondary memory space to contain rows from several tables is called:

Discuss the advantages and disadvantages of partitioning.

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

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

Horizontal partitioning is very different from creating a supertype/subtype relationship.

How are missing values generally handled in database management systems?

A hashing algorithm is a routine that converts a primary key value into a relative record number.

Horizontal partitioning makes sense:

An integrity control supported by a DBMS is:

In most cases the goal of ________ dominates the design process.

A(n)________ is a field of data used to locate a related field or record.

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

A contiguous section of disk storage space is called a(n):

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

The smallest unit of named application data is a record.

Denormalization is the process of transforming normalized relations into ________ physical record specifications.

Parallel query processing speed is not significantly different from running queries in a non-parallel mode.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 5: Physical Database Design and Performance

________ is often used to decide whether or not missing data can be ignored.

A(n)________ is defined by the tables and column of columns by which the tables are joined.

All of the following are common denormalization opportunities EXCEPT:

A method to allow adjacent secondary memory space to contain rows from several tables is called:

Discuss the advantages and disadvantages of partitioning.

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

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

Horizontal partitioning is very different from creating a supertype/subtype relationship.

How are missing values generally handled in database management systems?

A hashing algorithm is a routine that converts a primary key value into a relative record number.

Horizontal partitioning makes sense:

An integrity control supported by a DBMS is:

In most cases the goal of ________ dominates the design process.

A(n)________ is a field of data used to locate a related field or record.

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

A contiguous section of disk storage space is called a(n):

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

The smallest unit of named application data is a record.

Denormalization is the process of transforming normalized relations into ________ physical record specifications.

Parallel query processing speed is not significantly different from running queries in a non-parallel mode.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters