Question 1

In which type of file is multiple key retrieval not possible?

Accepted Answer

A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered 
A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered

Question 2

Explain what primary,secondary and unique key indexes are.

Accepted Answer

A primary key index is automatically gen

Question 3

Sensitivity testing involves:

Accepted Answer

A)  checking to see if you teeth hurt when you brush. 
B)  seeing how accurate data are. 
C)  checking to see if missing data will greatly impact results. 
D)  none of the above. 
A)  checking to see if you teeth hurt when you brush. 
B)  seeing how accurate data are. 
C)  checking to see if missing data will greatly impact results. 
D)  none of the above.

Question 4

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

Accepted Answer

A)  multiple partition queries. 
B)  perpendicular query processing. 
C)  parallel query processing. 
D)  query optimization. 
A)  multiple partition queries. 
B)  perpendicular query processing. 
C)  parallel query processing. 
D)  query optimization.

Question 5

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

Accepted Answer

The answer of A ________ is a named set of...

Question 6

All of the following are horizontal partitioning methods in Oracle EXCEPT:

Accepted Answer

A)  key range partitioning. 
B)  hash partitioning. 
C)  multivalued partitioning. 
D)  composite partitioning. 
A)  key range partitioning. 
B)  hash partitioning. 
C)  multivalued partitioning. 
D)  composite partitioning.

Question 7

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ is a technique for physically arranging the records of a file on secondary storage devices.

Accepted Answer

A)  physical pointer 
B)  retrieval program 
C)  file organization 
D)  update program 
A)  physical pointer 
B)  retrieval program 
C)  file organization 
D)  update program

Question 9

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.

Question 10

What is parallel query processing and how is it useful?

Accepted Answer

Since many of today's computers have eit

Question 11

Which type of file is easiest to update?

Accepted Answer

A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered 
A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered

Question 12

Along with table scans,other elements of a query can be processed in parallel.

Accepted Answer

A) True 
 B)False

Question 13

A method for handling missing data is to:

Accepted Answer

A)  substitute and estimate for the missing data. 
B)  track missing data with special reports. 
C)  perform sensitivity testing. 
D)  all of the above. 
A)  substitute and estimate for the missing data. 
B)  track missing data with special reports. 
C)  perform sensitivity testing. 
D)  all of the above.

Question 14

An index on columns from two or more tables that come from the same domain of values is called a(n)________ index.

Accepted Answer

The answer of An index on columns from two or...

Question 15

The query processor always knows the best way to process a query.

Accepted Answer

A) True 
 B)False

Question 16

One method to handle missing values is to substitute an exact value.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Indexes are most useful on small,clustered files.

Accepted Answer

A) True 
 B)False

Question 19

A rule of thumb for choosing indexes is to:

Accepted Answer

A)  be careful indexing attributes that may be null. 
B)  index each primary key of each table. 
C)  use an index when there is variety in attribute values. 
D)  all of the above. 
A)  be careful indexing attributes that may be null. 
B)  index each primary key of each table. 
C)  use an index when there is variety in attribute values. 
D)  all of the above.

Question 20

Another form of denormalization where the same data are stored in multiple places in the database is called:

Accepted Answer

A)  data duplication. 
B)  data replication. 
C)  advanced placement. 
D)  horizontal partitioning. 
A)  data duplication. 
B)  data replication. 
C)  advanced placement. 
D)  horizontal partitioning.

In which type of file is multiple key retrieval not possible?

Explain what primary,secondary and unique key indexes are.

Sensitivity testing involves:

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

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

All of the following are horizontal partitioning methods in Oracle EXCEPT:

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A(n)________ is a technique for physically arranging the records of a file on secondary storage devices.

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

What is parallel query processing and how is it useful?

Which type of file is easiest to update?

Along with table scans,other elements of a query can be processed in parallel.

A method for handling missing data is to:

An index on columns from two or more tables that come from the same domain of values is called a(n)________ index.

The query processor always knows the best way to process a query.

One method to handle missing values is to substitute an exact value.

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

Indexes are most useful on small,clustered files.

A rule of thumb for choosing indexes is to:

Another form of denormalization where the same data are stored in multiple places in the database is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 5: Physical Database Design and Performance

In which type of file is multiple key retrieval not possible?

Explain what primary,secondary and unique key indexes are.

Sensitivity testing involves:

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

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

All of the following are horizontal partitioning methods in Oracle EXCEPT:

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A(n)________ is a technique for physically arranging the records of a file on secondary storage devices.

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

What is parallel query processing and how is it useful?

Which type of file is easiest to update?

Along with table scans,other elements of a query can be processed in parallel.

A method for handling missing data is to:

An index on columns from two or more tables that come from the same domain of values is called a(n)________ index.

The query processor always knows the best way to process a query.

One method to handle missing values is to substitute an exact value.

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

Indexes are most useful on small,clustered files.

A rule of thumb for choosing indexes is to:

Another form of denormalization where the same data are stored in multiple places in the database is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters