Question 1

Primary keys are good candidates for being indexed but foreign keys are not.

Accepted Answer

A) True 
 B)False

Question 2

Storing derived data improves performance in the case where calculated values have to be repeatedly derived.

Accepted Answer

A) True 
 B)False

Question 3

All of the following are steps in finding and transferring data from disk, except _____.

Accepted Answer

A)  seek time 
B)  head switching 
C)  rotational delay 
D)  scan time 
E)  transfer time 
A)  seek time 
B)  head switching 
C)  rotational delay 
D)  scan time 
E)  transfer time

Question 4

Create a simple linear index for the Animal file based on:
a. The Animal Name field.
b. The Species field.
c. The Animal Number field.
d. The combination of the Species and Animal Name fields.

Accepted Answer

a. (Based on Animal Name)
 @#IMG-DLM& b.

Question 5

In the physical design technique known as "substituting foreign keys", the table with the foreign key in it has its primary and foreign keys interchanged.

Accepted Answer

A) True 
 B)False

Question 6

In a magnetic disk device, a set of tracks, one above the other (and one from each recording surface) is called a _____.

Accepted Answer

A)  CD 
B)  cylinder 
C)  hard disk 
D)  read/write head 
E)  platter 
A)  CD 
B)  cylinder 
C)  hard disk 
D)  read/write head 
E)  platter

Question 7

Create a simple linear index for the Animal file based on:
a. The Year Built field.
b. The Manufacturer field.
c. The Airplane Number field.
d. The combination of the Manufacturer and Year Built fields.

Accepted Answer

a. (Based on Year Built)
 @#IMG-DLM& b.

Question 8

An index can only be built over a field that has unique values.

Accepted Answer

A) True 
 B)False

Question 9

The clustering files technique can result in slower performance when the records of only one of the files involved must be retrieved.

Accepted Answer

A) True 
 B)False

Question 10

In a hashed file using the division remainder method _____.

Accepted Answer

A)  a collision results from the key values of two records having the same quotient in the hashing calculation 
B)  a collision results from the key values of two records having the same remainder in the hashing calculation 
C)  a collision results from the key values of two records having a combination of the same quotient and the same remainder in the hashing calculation 
D)  All of the above. 
E)  None of the above. 
A)  a collision results from the key values of two records having the same quotient in the hashing calculation 
B)  a collision results from the key values of two records having the same remainder in the hashing calculation 
C)  a collision results from the key values of two records having a combination of the same quotient and the same remainder in the hashing calculation 
D)  All of the above. 
E)  None of the above.

Question 11

All of the following are characteristics of an indexed computer file and its index, except _____.

Accepted Answer

A)  the records of the file are sorted into the same order as the values in the index 
B)  a set of field values is copied from the file into the index 
C)  the field values copied into the index are sorted in the index 
D)  the field values in the index are associated with the location of the records in the file from which they were copied 
E)  the index consists of two columns, one for the field values copied from the file and one for the pointers back to the records of the file. 
A)  the records of the file are sorted into the same order as the values in the index 
B)  a set of field values is copied from the file into the index 
C)  the field values copied into the index are sorted in the index 
D)  the field values in the index are associated with the location of the records in the file from which they were copied 
E)  the index consists of two columns, one for the field values copied from the file and one for the pointers back to the records of the file.

Question 12

Which of the following is true regarding hashed files?

Accepted Answer

A)  The hashing algorithm may direct more than one record to the same location. 
B)  The number of record storage locations allocated is typically much fewer than the maximum number possible based on the range of values of the key field. 
C)  The same hashing algorithm is used for both record insertions and record retrievals. 
D)  All of the above. 
E)  None of the above. 
A)  The hashing algorithm may direct more than one record to the same location. 
B)  The number of record storage locations allocated is typically much fewer than the maximum number possible based on the range of values of the key field. 
C)  The same hashing algorithm is used for both record insertions and record retrievals. 
D)  All of the above. 
E)  None of the above.

Question 13

Vertical partitioning ____.

Accepted Answer

A)  means dividing the rows of a table into groups and storing the groups separately, on different areas of a disk or on different disks 
B)  means dividing the columns of a table into groups and storing the groups separately, on different areas of a disk or on different disks 
C)  may involve splitting large text attributes off from the rest of a table 
D)  a & c above 
E)  b & c above 
A)  means dividing the rows of a table into groups and storing the groups separately, on different areas of a disk or on different disks 
B)  means dividing the columns of a table into groups and storing the groups separately, on different areas of a disk or on different disks 
C)  may involve splitting large text attributes off from the rest of a table 
D)  a & c above 
E)  b & c above

Question 14

Modifying the logical database design to improve performance may reintroduce data redundancy.

Accepted Answer

A) True 
 B)False

Question 15

Data volatility refers to how often stored data is updated.

Accepted Answer

A) True 
 B)False

Question 16

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. Denormalization ____.

Accepted Answer

A)  maintains the data in the two tables 
B)  combines the data in the two tables into one table 
C)  creates a third table 
D)  creates additional indexes 
E)  creates additional repeating groups 
A)  maintains the data in the two tables 
B)  combines the data in the two tables into one table 
C)  creates a third table 
D)  creates additional indexes 
E)  creates additional repeating groups

Question 17

Every record insertion in a B+-tree indexed file requires a track split and some may also require cylinder splits.

Accepted Answer

A) True 
 B)False

Question 18

The dispersal of data on a disk is unrelated to database performance.

Accepted Answer

A) True 
 B)False

Question 19

The cylinder concept exists because access arm mechanism movement is so slow that it affects computer and application performance.

Accepted Answer

A) True 
 B)False

Question 20

The average rotational delay is one-half of a disk revolution.

Accepted Answer

A) True 
 B)False

Primary keys are good candidates for being indexed but foreign keys are not.

Storing derived data improves performance in the case where calculated values have to be repeatedly derived.

All of the following are steps in finding and transferring data from disk, except _____.

Create a simple linear index for the Animal file based on: a. The Animal Name field. b. The Species field. c. The Animal Number field. d. The combination of the Species and Animal Name fields.

In the physical design technique known as "substituting foreign keys", the table with the foreign key in it has its primary and foreign keys interchanged.

In a magnetic disk device, a set of tracks, one above the other (and one from each recording surface) is called a _____.

Create a simple linear index for the Animal file based on: a. The Year Built field. b. The Manufacturer field. c. The Airplane Number field. d. The combination of the Manufacturer and Year Built fields.

An index can only be built over a field that has unique values.

The clustering files technique can result in slower performance when the records of only one of the files involved must be retrieved.

In a hashed file using the division remainder method _____.

All of the following are characteristics of an indexed computer file and its index, except _____.

Which of the following is true regarding hashed files?

Vertical partitioning ____.

Modifying the logical database design to improve performance may reintroduce data redundancy.

Data volatility refers to how often stored data is updated.

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. Denormalization ____.

Every record insertion in a B+-tree indexed file requires a track split and some may also require cylinder splits.

The dispersal of data on a disk is unrelated to database performance.

The cylinder concept exists because access arm mechanism movement is so slow that it affects computer and application performance.

The average rotational delay is one-half of a disk revolution.

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

Primary keys are good candidates for being indexed but foreign keys are not.

Storing derived data improves performance in the case where calculated values have to be repeatedly derived.

All of the following are steps in finding and transferring data from disk, except _____.

Create a simple linear index for the Animal file based on: a. The Animal Name field. b. The Species field. c. The Animal Number field. d. The combination of the Species and Animal Name fields.

In the physical design technique known as "substituting foreign keys", the table with the foreign key in it has its primary and foreign keys interchanged.

In a magnetic disk device, a set of tracks, one above the other (and one from each recording surface) is called a _____.

Create a simple linear index for the Animal file based on: a. The Year Built field. b. The Manufacturer field. c. The Airplane Number field. d. The combination of the Manufacturer and Year Built fields.

An index can only be built over a field that has unique values.

The clustering files technique can result in slower performance when the records of only one of the files involved must be retrieved.

In a hashed file using the division remainder method _____.

All of the following are characteristics of an indexed computer file and its index, except _____.

Which of the following is true regarding hashed files?

Vertical partitioning ____.

Modifying the logical database design to improve performance may reintroduce data redundancy.

Data volatility refers to how often stored data is updated.

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. Denormalization ____.

Every record insertion in a B+-tree indexed file requires a track split and some may also require cylinder splits.

The dispersal of data on a disk is unrelated to database performance.

The cylinder concept exists because access arm mechanism movement is so slow that it affects computer and application performance.

The average rotational delay is one-half of a disk revolution.

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