Question 1

One of the main potential problems in relational database performance is the speed with which join operations take place.

Accepted Answer

A) True 
 B)False

Question 2

Storing derived data improves performance in the case where a primary key consists of several attributes and is found to be clumsy in practice.

Accepted Answer

A) True 
 B)False

Question 3

A record insertion in a B+-tree index may require either a track split or a cylinder split, but not both for a given insertion.

Accepted Answer

A) True 
 B)False

Question 4

Direct access can be achieved _____.

Accepted Answer

A)  with an index but not with a hashing method 
B)  with a hashing method but not with an index 
C)  with neither an index nor a hashing method 
D)  with either an index or a hashing method 
E)  only with the combined use of an index and a hashing method 
A)  with an index but not with a hashing method 
B)  with a hashing method but not with an index 
C)  with neither an index nor a hashing method 
D)  with either an index or a hashing method 
E)  only with the combined use of an index and a hashing method

Question 5

Both horizontal and vertical partitioning can improve performance by reducing bottlenecks that form when too many applications or users attempt to access the same table.

Accepted Answer

A) True 
 B)False

Question 6

\(\begin{array}{lllll}
\begin{array}{lll}
\text { Course } \quad\quad  \text { Record }\
\text { Name } \quad \quad \text { Address }\
\begin{array}{|l|l|}
\hline \text { Anatomy } & 2 \
\hline \text { Biology I } & 1 \
\hline \text { Calculus I } & 4 \
\hline \text { Shakespeare } & 3 \
\hline \text { Statistics II } & 5 \
\hline
\end{array}\\text { Index }\end{array}
&\begin{array}{lllll}\text { Record }&\text { Course\quad\quad\quad Course\quad\quad\quad\quad Number of\quad Professor }\
\text { Number }&\text { Number\quad\quad\quad Name\quad\quad\quad\quad Credits\quad\quad in Charge }\
\begin{array}{lr}
1\2\3\4\5
\end{array}&\begin{array}{|l|l|l|l|}
\hline \text { BIOL1001 } & \text { Biology I } & 4 \quad\quad\quad& \text { Smith } \
\hline \text { BIOL3020 } & \text { Anatomy } & 3 & \text { Jones } \
\hline \text { ENGL2540 } & \text { Shakespeare } & 3 & \text { Duncan } \
\hline \text { MATH2000 } & \text { Calculus I } & 4 & \text { Stevens } \
\hline \text { MATH3500 } & \text { Statistics II } & 3 & \text { Jones } \
\hline\end{array}\
\end{array}\end{array}\)
-In an indexed sequential file _____.

Accepted Answer

A)  only one field may be indexed 
B)  the field on which the file is sequenced must be indexed 
C)  a field other than the one on which the file is sequenced must be indexed 
D)  it is possible that there is no index 
E)  the record addresses in the index must be sorted 
A)  only one field may be indexed 
B)  the field on which the file is sequenced must be indexed 
C)  a field other than the one on which the file is sequenced must be indexed 
D)  it is possible that there is no index 
E)  the record addresses in the index must be sorted

Question 7

Denormalization can improve the ____.

Accepted Answer

A)  performance of the database by reducing the number of join operations 
B)  integrity of the database by reducing the amount of redundant data 
C)  accuracy of the database by reducing the number of repeating groups 
D)  All of the above. 
E)  None of the above. 
A)  performance of the database by reducing the number of join operations 
B)  integrity of the database by reducing the amount of redundant data 
C)  accuracy of the database by reducing the number of repeating groups 
D)  All of the above. 
E)  None of the above.

Question 8

The first step in indexing a file using a simple linear index is to copy a set of field values from the file into the index and to sort them.

Accepted Answer

A) True 
 B)False

Question 9

Building indexes over relational tables always has a positive effect on performance and never has a negative effect.

Accepted Answer

A) True 
 B)False

Question 10

Combining two tables that represent a one-to-one relationship ____.

Accepted Answer

A)  is designed to reduce the number of joins in the database environment 
B)  can result in the introduction of redundant data 
C)  can result in an increase in the total number of attributes involved in an individual data retrieval operation 
D)  All of the above. 
E)  None of the above. 
A)  is designed to reduce the number of joins in the database environment 
B)  can result in the introduction of redundant data 
C)  can result in an increase in the total number of attributes involved in an individual data retrieval operation 
D)  All of the above. 
E)  None of the above.

Question 11

Response time is the measure of how many queries from simultaneous users must be satisfied in a given period of time by the application set and the database that supports it.

Accepted Answer

A) True 
 B)False

Question 12

The drawback of denormalization is that it ____.

Accepted Answer

A)  increases the number of join operations 
B)  introduces data redundancy 
C)  limits the number of indexes in use 
D)  increases the number of repeating groups 
E)  impedes the relational query optimizer's performance 
A)  increases the number of join operations 
B)  introduces data redundancy 
C)  limits the number of indexes in use 
D)  increases the number of repeating groups 
E)  impedes the relational query optimizer's performance

Question 13

Adding duplicate tables to a database reduces access bottlenecks and has no negative effects.

Accepted Answer

A) True 
 B)False

Question 14

A record is inserted into a location in a hashed file based on the result of a hashing algorithm applied to the record's key value.

Accepted Answer

A) True 
 B)False

Question 15

In a magnetic disk device, the number of positions to which the access arm mechanism can move is equal to the number of _____.

Accepted Answer

A)  tracks in a cylinder 
B)  tracks on a recording surface 
C)  tracks in the entire disk device 
D)  read/write heads 
E)  platters 
A)  tracks in a cylinder 
B)  tracks on a recording surface 
C)  tracks in the entire disk device 
D)  read/write heads 
E)  platters

Question 16

The volume of data in the database does not enter into database performance.

Accepted Answer

A) True 
 B)False

Question 17

The main input to the logical database design process is the output of the physical database design process.

Accepted Answer

A) True 
 B)False

Question 18

In a magnetic disk device, the reason for storing data on a cylinder-wise basis is _____.

Accepted Answer

A)  to avoid scratching the recording surfaces which would result in lost data 
B)  because more data can fit on a cylinder than on a recording surface 
C)  to minimize access arm movement in order to improve performance 
D)  because cylinders are the most stable of the disk device features 
E)  to be able to store the maximum amount of data on the disk device 
A)  to avoid scratching the recording surfaces which would result in lost data 
B)  because more data can fit on a cylinder than on a recording surface 
C)  to minimize access arm movement in order to improve performance 
D)  because cylinders are the most stable of the disk device features 
E)  to be able to store the maximum amount of data on the disk device

Question 19

When a new record is inserted into a file, an existing record is deleted, or an indexed field is updated, all of the affected indexes must be updated.

Accepted Answer

A) True 
 B)False

Question 20

The advantage of using the substituting foreign keys physical database design technique is that it is designed to ____.

Accepted Answer

A)  reduce the number of joins 
B)  reduce the number of indexes 
C)  reduce the number of attributes in large, clumsy keys 
D)  All of the above. 
E)  None of the above. 
A)  reduce the number of joins 
B)  reduce the number of indexes 
C)  reduce the number of attributes in large, clumsy keys 
D)  All of the above. 
E)  None of the above.

One of the main potential problems in relational database performance is the speed with which join operations take place.

Storing derived data improves performance in the case where a primary key consists of several attributes and is found to be clumsy in practice.

A record insertion in a B+-tree index may require either a track split or a cylinder split, but not both for a given insertion.

Direct access can be achieved _____.

Both horizontal and vertical partitioning can improve performance by reducing bottlenecks that form when too many applications or users attempt to access the same table.

Denormalization can improve the ____.

The first step in indexing a file using a simple linear index is to copy a set of field values from the file into the index and to sort them.

Building indexes over relational tables always has a positive effect on performance and never has a negative effect.

Combining two tables that represent a one-to-one relationship ____.

Response time is the measure of how many queries from simultaneous users must be satisfied in a given period of time by the application set and the database that supports it.

The drawback of denormalization is that it ____.

Adding duplicate tables to a database reduces access bottlenecks and has no negative effects.

A record is inserted into a location in a hashed file based on the result of a hashing algorithm applied to the record's key value.

In a magnetic disk device, the number of positions to which the access arm mechanism can move is equal to the number of _____.

The volume of data in the database does not enter into database performance.

The main input to the logical database design process is the output of the physical database design process.

In a magnetic disk device, the reason for storing data on a cylinder-wise basis is _____.

When a new record is inserted into a file, an existing record is deleted, or an indexed field is updated, all of the affected indexes must be updated.

The advantage of using the substituting foreign keys physical database design technique is that it is designed to ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 8: Physical Database Design

One of the main potential problems in relational database performance is the speed with which join operations take place.

Storing derived data improves performance in the case where a primary key consists of several attributes and is found to be clumsy in practice.

A record insertion in a B+-tree index may require either a track split or a cylinder split, but not both for a given insertion.

Direct access can be achieved _____.

Both horizontal and vertical partitioning can improve performance by reducing bottlenecks that form when too many applications or users attempt to access the same table.

Denormalization can improve the ____.

The first step in indexing a file using a simple linear index is to copy a set of field values from the file into the index and to sort them.

Building indexes over relational tables always has a positive effect on performance and never has a negative effect.

Combining two tables that represent a one-to-one relationship ____.

Response time is the measure of how many queries from simultaneous users must be satisfied in a given period of time by the application set and the database that supports it.

The drawback of denormalization is that it ____.

Adding duplicate tables to a database reduces access bottlenecks and has no negative effects.

A record is inserted into a location in a hashed file based on the result of a hashing algorithm applied to the record's key value.

In a magnetic disk device, the number of positions to which the access arm mechanism can move is equal to the number of _____.

The volume of data in the database does not enter into database performance.

The main input to the logical database design process is the output of the physical database design process.

In a magnetic disk device, the reason for storing data on a cylinder-wise basis is _____.

When a new record is inserted into a file, an existing record is deleted, or an indexed field is updated, all of the affected indexes must be updated.

The advantage of using the substituting foreign keys physical database design technique is that it is designed to ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters