Question 1

A "fixed" or "hard" disk drive operates with removable diskettes.

Accepted Answer

A) True 
 B)False

Question 2

If the primary key of a table is clumsy because it has too many attributes and is replaced by a new, single attribute key, ____.

Accepted Answer

A)  it becomes the new primary key of its own table 
B)  it should replace the old primary key where it was used as a foreign key for one-to-many relationships 
C)  it should replace the old primary key where it was used as a foreign key for many-to-many relationships 
D)  All of the above. 
E)  None of the above. 
A)  it becomes the new primary key of its own table 
B)  it should replace the old primary key where it was used as a foreign key for one-to-many relationships 
C)  it should replace the old primary key where it was used as a foreign key for many-to-many relationships 
D)  All of the above. 
E)  None of the above.

Question 3

All of the following are advantages of the B+-tree index arrangement, compared to the simple linear index arrangement, except _____.

Accepted Answer

A)  The upper portion of the tree index can be held in main memory indefinitely to improve performance. 
B)  The insertion of a new record requires either a track split or a cylinder split, but not both for a single insertion. 
C)  Even for large files, only a small number of index records have to be read for a direct search. 
D)  The nature of the index together with the track split and cylinder split capabilities make record insertions manageable. 
E)  Some insertions can be made without track splits or cylinder splits if reserve space has been provided on the data tracks. 
A)  The upper portion of the tree index can be held in main memory indefinitely to improve performance. 
B)  The insertion of a new record requires either a track split or a cylinder split, but not both for a single insertion. 
C)  Even for large files, only a small number of index records have to be read for a direct search. 
D)  The nature of the index together with the track split and cylinder split capabilities make record insertions manageable. 
E)  Some insertions can be made without track splits or cylinder splits if reserve space has been provided on the data tracks.

Question 4

Denormalization improves the performance of join operations at the expense of reintroducing data redundancy.

Accepted Answer

A) True 
 B)False

Question 5

In the B+-tree index arrangement described in the text, the lowest level of the index tree is stored using a track in each data cylinder.

Accepted Answer

A) True 
 B)False

Question 6

Clustering files disperses logically related data from two tables to different parts of the disk.

Accepted Answer

A) True 
 B)False

Question 7

Construct a B+-tree index of the type discussed in the text for the Animal file, assuming that now there are many more records than are shown above
. The file and the index have the following characteristics:
-The file is stored on eight cylinders of the disk. The highest key values on the eight cylinders, in order, are:
Cylinder 1: 03583
Cylinder 2: 08437
Cylinder 3: 18965
Cylinder 4: 27028
Cylinder 5: 41603
Cylinder 6: 53781
Cylinder 7: 68337
Cylinder 8: 80174
-Each index record can hold four key value/pointer pairs.
-There are three index records at the lowest level of the tree index.

Accepted Answer

\(\begin{array}{ccc}
&\begin{array}{|l|l

Question 8

A hashed file has space for 80 records. Relative record numbers of 0-79 label each of the 80 record positions. In addition, there is space for several overflow (synonym) records. Draw a picture of the file and using the division-remainder method, store records with each of the following five digit keys, accounting for collisions as necessary:
a. 27043.
b. 36235.
c. 06003.
d. 40963.

Accepted Answer

a. The record with key value 27043 is pl

Question 9

In addition to its direct access capability, an index can be used to retrieve the records of a file in logical sequence based on the indexed field.

Accepted Answer

A) True 
 B)False

Question 10

Construct a B+-tree index of the type discussed in the text for the Animal file, assuming that now there are many more records than are shown above. The file and the index have the following characteristics:
-The file is stored on eight cylinders of the disk. The highest key values on the eight cylinders, in order, are:
Cylinder 1: 03583
Cylinder 2: 08437
Cylinder 3: 18965
Cylinder 4: 27028
Cylinder 5: 41603
Cylinder 6: 53781
Cylinder 7: 68337
Cylinder 8: 80174
-Each index record can hold two key value/pointer pairs.
-There are four index records at the lowest level of the tree index.

Accepted Answer

\[\begin{array}{l}
\begin{array}{|l|l|}

Question 11

If a file is hashed on one field, direct access based on another field can be achieved by building an index on the other field.

Accepted Answer

A) True 
 B)False

Question 12

Creating views actually changes the logical database design.

Accepted Answer

A) True 
 B)False

Question 13

The starting point of the physical database design process is ____.

Accepted Answer

A)  the creation of indexes over the relational tables 
B)  the output of the logical database design process 
C)  the denormalized tables 
D)  the unnormalized data 
E)  the set of entities, attributes, and relationships 
A)  the creation of indexes over the relational tables 
B)  the output of the logical database design process 
C)  the denormalized tables 
D)  the unnormalized data 
E)  the set of entities, attributes, and relationships

Question 14

The more volatile the data in a table, the less will be the negative performance effect of having a relatively large number of indexes built over it.

Accepted Answer

A) True 
 B)False

Question 15

Some physical database design techniques actually change the logical design while others do not.

Accepted Answer

A) True 
 B)False

Question 16

The way that data is retrieved, based on it being stored with a particular access method, is called its file organization.

Accepted Answer

A) True 
 B)False

Question 17

Factors in the applications that use databases can affect database performance.

Accepted Answer

A) True 
 B)False

Question 18

In a magnetic disk device, the number of tracks in a cylinder is equal to the number of _____.

Accepted Answer

A)  tracks on a recording surface 
B)  cylinders 
C)  recording surfaces 
D)  read/write heads 
E)  platters 
A)  tracks on a recording surface 
B)  cylinders 
C)  recording surfaces 
D)  read/write heads 
E)  platters

Question 19

One of the advantages of B+-tree indexes is that they can handle record insertions more easily than simple linear indexes.

Accepted Answer

A) True 
 B)False

Question 20

Hashed files _____.

Accepted Answer

A)  are stored in physical sequence based on the hashed field values 
B)  can be hashed separately on different fields simultaneously, just as indexed files can have indexes built separately on different fields simultaneously 
C)  never need to be reorganized 
D)  can also have indexes built over them 
E)  cannot also have indexes built over them 
A)  are stored in physical sequence based on the hashed field values 
B)  can be hashed separately on different fields simultaneously, just as indexed files can have indexes built separately on different fields simultaneously 
C)  never need to be reorganized 
D)  can also have indexes built over them 
E)  cannot also have indexes built over them

A "fixed" or "hard" disk drive operates with removable diskettes.

If the primary key of a table is clumsy because it has too many attributes and is replaced by a new, single attribute key, ____.

All of the following are advantages of the B+-tree index arrangement, compared to the simple linear index arrangement, except _____.

Denormalization improves the performance of join operations at the expense of reintroducing data redundancy.

In the B+-tree index arrangement described in the text, the lowest level of the index tree is stored using a track in each data cylinder.

Clustering files disperses logically related data from two tables to different parts of the disk.

In addition to its direct access capability, an index can be used to retrieve the records of a file in logical sequence based on the indexed field.

If a file is hashed on one field, direct access based on another field can be achieved by building an index on the other field.

Creating views actually changes the logical database design.

The starting point of the physical database design process is ____.

The more volatile the data in a table, the less will be the negative performance effect of having a relatively large number of indexes built over it.

Some physical database design techniques actually change the logical design while others do not.

The way that data is retrieved, based on it being stored with a particular access method, is called its file organization.

Factors in the applications that use databases can affect database performance.

In a magnetic disk device, the number of tracks in a cylinder is equal to the number of _____.

One of the advantages of B+-tree indexes is that they can handle record insertions more easily than simple linear indexes.

Hashed files _____.

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

A "fixed" or "hard" disk drive operates with removable diskettes.

If the primary key of a table is clumsy because it has too many attributes and is replaced by a new, single attribute key, ____.

All of the following are advantages of the B+-tree index arrangement, compared to the simple linear index arrangement, except _____.

Denormalization improves the performance of join operations at the expense of reintroducing data redundancy.

In the B+-tree index arrangement described in the text, the lowest level of the index tree is stored using a track in each data cylinder.

Clustering files disperses logically related data from two tables to different parts of the disk.

In addition to its direct access capability, an index can be used to retrieve the records of a file in logical sequence based on the indexed field.

If a file is hashed on one field, direct access based on another field can be achieved by building an index on the other field.

Creating views actually changes the logical database design.

The starting point of the physical database design process is ____.

The more volatile the data in a table, the less will be the negative performance effect of having a relatively large number of indexes built over it.

Some physical database design techniques actually change the logical design while others do not.

The way that data is retrieved, based on it being stored with a particular access method, is called its file organization.

Factors in the applications that use databases can affect database performance.

In a magnetic disk device, the number of tracks in a cylinder is equal to the number of _____.

One of the advantages of B+-tree indexes is that they can handle record insertions more easily than simple linear indexes.

Hashed files _____.

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