Question 1

Designing physical files requires ________ of where and when data are used in various ways.

Accepted Answer

A)  maps 
B)  descriptions 
C)  keys 
D)  hints 
A)  maps 
B)  descriptions 
C)  keys 
D)  hints

Question 2

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.

Accepted Answer

A) True 
 B)False

Question 3

Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.

Accepted Answer

A) True 
 B)False

Question 4

The logical database design always forms the best foundation for grouping attributes in the physical design.

Accepted Answer

A) True 
 B)False

Question 5

What is a hashing algorithm and how is it used in hashed file organizations?

Accepted Answer

A hashing algorithm is a routine which c

Question 6

A join index is a combination of two or more indexes.

Accepted Answer

A) True 
 B)False

Question 7

A requirement to begin designing physical files and databases is:

Accepted Answer

A)  normalized relations. 
B)  physical tables created. 
C)  implementation complete. 
D)  all datatypes determined. 
A)  normalized relations. 
B)  physical tables created. 
C)  implementation complete. 
D)  all datatypes determined.

Question 8

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 9

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

Accepted Answer

A) True 
 B)False

Question 10

A pointer is a field of data that can be used to locate a related field or record of data.

Accepted Answer

A) True 
 B)False

Question 11

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

Accepted Answer

A)  extent. 
B)  table. 
C)  tablespace. 
D)  partition. 
A)  extent. 
B)  table. 
C)  tablespace. 
D)  partition.

Question 12

A file organization where files are not stored in any particular order is considered a:

Accepted Answer

A)  hashed file organization. 
B)  hash key. 
C)  multi-indexed file organization. 
D)  heap file organization. 
A)  hashed file organization. 
B)  hash key. 
C)  multi-indexed file organization. 
D)  heap file organization.

Question 13

What is parallel query processing and how is it useful?

Accepted Answer

Since many of today's computers have eit

Question 14

Explain how one goes about choosing data types.

Accepted Answer

Selecting a datatype involves four objec

Question 15

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

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

One objective of selecting a data type is to minimize storage space.

Accepted Answer

A) True 
 B)False

Question 18

________ partitioning distributes the columns of a table into several separate physical records.

Accepted Answer

A)  Horizontal 
B)  Crossways 
C)  Vertical 
D)  Final 
A)  Horizontal 
B)  Crossways 
C)  Vertical 
D)  Final

Question 19

All of the following are objectives when selecting a data type EXCEPT:

Accepted Answer

A)  represent all possible values. 
B)  improve data integrity. 
C)  support all data manipulations. 
D)  use a lot of storage space. 
A)  represent all possible values. 
B)  improve data integrity. 
C)  support all data manipulations. 
D)  use a lot of storage space.

Question 20

An index on columns from two or more tables that come from the same domain of values is called a:

Accepted Answer

A)  bitmap index. 
B)  multivalued index. 
C)  join index. 
D)  transaction index. 
A)  bitmap index. 
B)  multivalued index. 
C)  join index. 
D)  transaction index.

Designing physical files requires ________ of where and when data are used in various ways.

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.

Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.

The logical database design always forms the best foundation for grouping attributes in the physical design.

What is a hashing algorithm and how is it used in hashed file organizations?

A join index is a combination of two or more indexes.

A requirement to begin designing physical files and databases is:

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

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

A pointer is a field of data that can be used to locate a related field or record of data.

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

A file organization where files are not stored in any particular order is considered a:

What is parallel query processing and how is it useful?

Explain how one goes about choosing data types.

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

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

One objective of selecting a data type is to minimize storage space.

________ partitioning distributes the columns of a table into several separate physical records.

All of the following are objectives when selecting a data type EXCEPT:

An index on columns from two or more tables that come from the same domain of values is called a:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 5: Physical Database Design and Performance

Designing physical files requires ________ of where and when data are used in various ways.

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.

Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.

The logical database design always forms the best foundation for grouping attributes in the physical design.

What is a hashing algorithm and how is it used in hashed file organizations?

A join index is a combination of two or more indexes.

A requirement to begin designing physical files and databases is:

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

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

A pointer is a field of data that can be used to locate a related field or record of data.

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

A file organization where files are not stored in any particular order is considered a:

What is parallel query processing and how is it useful?

Explain how one goes about choosing data types.

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

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

One objective of selecting a data type is to minimize storage space.

________ partitioning distributes the columns of a table into several separate physical records.

All of the following are objectives when selecting a data type EXCEPT:

An index on columns from two or more tables that come from the same domain of values is called a:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters