Question 1

Physical database design is the process of modifying the logical database design to improve performance.

Accepted Answer

A) True 
 B)False  True

Question 2

All of the following are inputs into the physical database design process, except ____.

Accepted Answer

A)  application data requirements 
B)  throughput requirements 
C)  hardware characteristics 
D)  functional dependencies 
E)  application priorities 
A)  application data requirements 
B)  throughput requirements 
C)  hardware characteristics 
D)  functional dependencies 
E)  application priorities D

Question 3

One of the reasons for having secondary memory is that primary memory cannot possibly hold all of a company's programs and data.

Accepted Answer

A) True 
 B)False  True

Question 4

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 six cylinders of the disk. The highest key values on the six cylinders, in order, are:
Cylinder 1: 08574
Cylinder 2: 12740
Cylinder 3: 19025
Cylinder 4: 24859
Cylinder 5: 31745
Cylinder 6: 42853
-Each index record can hold two key value/pointer pairs.
-There are three index records at the lowest level of the tree index.

Accepted Answer

\(\begin{array}{lr}\begin{array}{|l|l|}

Question 5

Tracks are concentric circles of data on a recording surface of a disk.

Accepted Answer

A) True 
 B)False

Question 6

Horizontal 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 7

All of the following are factors affecting application and database performance, except ____.

Accepted Answer

A)  the length of attribute names 
B)  large data volumes 
C)  the number of data access operations 
D)  the need for joins 
E)  related data dispersed on the disk 
A)  the length of attribute names 
B)  large data volumes 
C)  the number of data access operations 
D)  the need for joins 
E)  related data dispersed on the disk

Question 8

Which of the following is a potential problem caused by adding too many indexes to a relational database?

Accepted Answer

A)  Too many indexes can slow the performance of the database when there is a large amount of direct retrieval activity. 
B)  Updating the indexes when the data is updated can slow down queries executing at the same time. 
C)  Maintaining the security of the database can be adversely affected by the presence of a large number of indexes. 
D)  All of the above. 
E)  None of the above. 
A)  Too many indexes can slow the performance of the database when there is a large amount of direct retrieval activity. 
B)  Updating the indexes when the data is updated can slow down queries executing at the same time. 
C)  Maintaining the security of the database can be adversely affected by the presence of a large number of indexes. 
D)  All of the above. 
E)  None of the above.

Question 9

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. The primary key of Table A has been placed in Table B as a foreign key. The substituting foreign keys physical database design technique ____.

Accepted Answer

A)  can be performed if Table A has only one candidate key 
B)  cannot be performed if Table B has only one foreign key 
C)  can only be performed if Table A has more than one candidate key 
D)  can only be performed if Table B has more than one foreign key 
E)  None of the above. 
A)  can be performed if Table A has only one candidate key 
B)  cannot be performed if Table B has only one foreign key 
C)  can only be performed if Table A has more than one candidate key 
D)  can only be performed if Table B has more than one foreign key 
E)  None of the above.

Question 10

In a hashed file, the hashing algorithm may attempt to insert more than one record into a given record storage location.

Accepted Answer

A) True 
 B)False

Question 11

The creating a new primary key physical database design technique is designed to ____.

Accepted Answer

A)  reduce the number of joins 
B)  reduce the number of indexes 
C)  replace clumsy keys that have a large number of attributes 
D)  All of the above. 
E)  None of the above. 
A)  reduce the number of joins 
B)  reduce the number of indexes 
C)  replace clumsy keys that have a large number of attributes 
D)  All of the above. 
E)  None of the above.

Question 12

In the clustering files physical database design technique, ____ are clustered near each other on a disk.

Accepted Answer

A)  the records of a table 
B)  the records of a table with common values of a particular attribute 
C)  the columns of a table that are indexed 
D)  the columns of a table that are located next to each other 
E)  related records from different tables 
A)  the records of a table 
B)  the records of a table with common values of a particular attribute 
C)  the columns of a table that are indexed 
D)  the columns of a table that are located next to each other 
E)  related records from different tables

Question 13

The movement of a disk drive's access arm mechanism takes place at electronic, as opposed to mechanical, speeds.

Accepted Answer

A) True 
 B)False

Question 14

In a disk, once the access arm mechanism moves to a particular cylinder, every track of that cylinder can be accessed without further access arm mechanism movement.

Accepted Answer

A) True 
 B)False

Question 15

Physical database design is necessary ____.

Accepted Answer

A)  to eliminate the data redundancy left over from logical database design 
B)  to make the first pass at arranging the attributes into related groupings 
C)  to improve the performance of the run-time environment. 
D)  to place foreign keys where they need to be to model the relationships in the business environment 
E)  to prepare for logical database design 
A)  to eliminate the data redundancy left over from logical database design 
B)  to make the first pass at arranging the attributes into related groupings 
C)  to improve the performance of the run-time environment. 
D)  to place foreign keys where they need to be to model the relationships in the business environment 
E)  to prepare for logical database design

Question 16

Which of the following is true about indexes, in general?

Accepted Answer

A)  An index can only be built over a field that has unique values. 
B)  Only one field of a file can be indexed. 
C)  An index can be used to retrieve the records of a file in logical sequence based on the indexed field. 
D)  An index cannot be built over a combination of fields of a file. 
E)  The updating of an indexed field in a record requires that the index be updated but record insertions and record deletions do not require any index to be updated. 
A)  An index can only be built over a field that has unique values. 
B)  Only one field of a file can be indexed. 
C)  An index can be used to retrieve the records of a file in logical sequence based on the indexed field. 
D)  An index cannot be built over a combination of fields of a file. 
E)  The updating of an indexed field in a record requires that the index be updated but record insertions and record deletions do not require any index to be updated.

Question 17

A file can have only one index built over it.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are good candidates for having an index built over them, except ____.

Accepted Answer

A)  foreign key 
B)  search attribute 
C)  primary key 
D)  All of the above. 
E)  None of the above. 
A)  foreign key 
B)  search attribute 
C)  primary key 
D)  All of the above. 
E)  None of the above.

Question 19

In terms of performance, there is no point in indexing a table if ____.

Accepted Answer

A)  several of its attributes are not used as search fields 
B)  the number of rows of the table is very large 
C)  the number of rows of the table is very small 
D)  the number of columns of the table is fairly large 
E)  the number of columns of the table is fairly small 
A)  several of its attributes are not used as search fields 
B)  the number of rows of the table is very large 
C)  the number of rows of the table is very small 
D)  the number of columns of the table is fairly large 
E)  the number of columns of the table is fairly small

Question 20

Each entry in a simple linear index is associated with the record that it came from in the indexed file by recording the record's key field value in the index entry.

Accepted Answer

A) True 
 B)False

Physical database design is the process of modifying the logical database design to improve performance.

All of the following are inputs into the physical database design process, except ____.

One of the reasons for having secondary memory is that primary memory cannot possibly hold all of a company's programs and data.

Tracks are concentric circles of data on a recording surface of a disk.

Horizontal partitioning ____.

All of the following are factors affecting application and database performance, except ____.

Which of the following is a potential problem caused by adding too many indexes to a relational database?

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. The primary key of Table A has been placed in Table B as a foreign key. The substituting foreign keys physical database design technique ____.

In a hashed file, the hashing algorithm may attempt to insert more than one record into a given record storage location.

The creating a new primary key physical database design technique is designed to ____.

In the clustering files physical database design technique, ____ are clustered near each other on a disk.

The movement of a disk drive's access arm mechanism takes place at electronic, as opposed to mechanical, speeds.

In a disk, once the access arm mechanism moves to a particular cylinder, every track of that cylinder can be accessed without further access arm mechanism movement.

Physical database design is necessary ____.

Which of the following is true about indexes, in general?

A file can have only one index built over it.

All of the following are good candidates for having an index built over them, except ____.

In terms of performance, there is no point in indexing a table if ____.

Each entry in a simple linear index is associated with the record that it came from in the indexed file by recording the record's key field value in the index entry.

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

Physical database design is the process of modifying the logical database design to improve performance.

All of the following are inputs into the physical database design process, except ____.

One of the reasons for having secondary memory is that primary memory cannot possibly hold all of a company's programs and data.

Tracks are concentric circles of data on a recording surface of a disk.

Horizontal partitioning ____.

All of the following are factors affecting application and database performance, except ____.

Which of the following is a potential problem caused by adding too many indexes to a relational database?

Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. The primary key of Table A has been placed in Table B as a foreign key. The substituting foreign keys physical database design technique ____.

In a hashed file, the hashing algorithm may attempt to insert more than one record into a given record storage location.

The creating a new primary key physical database design technique is designed to ____.

In the clustering files physical database design technique, ____ are clustered near each other on a disk.

The movement of a disk drive's access arm mechanism takes place at electronic, as opposed to mechanical, speeds.

In a disk, once the access arm mechanism moves to a particular cylinder, every track of that cylinder can be accessed without further access arm mechanism movement.

Physical database design is necessary ____.

Which of the following is true about indexes, in general?

A file can have only one index built over it.

All of the following are good candidates for having an index built over them, except ____.

In terms of performance, there is no point in indexing a table if ____.

Each entry in a simple linear index is associated with the record that it came from in the indexed file by recording the record's key field value in the index entry.

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