Question 1

In order to perform a restore/rerun, the database must be mirrored.

Accepted Answer

A) True 
 B)False

Question 2

Which type of file is most efficient with storage space?

Accepted Answer

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

Question 3

A domain is a way to create a structure that acts like a table.

Accepted Answer

A) True 
 B)False

Question 4

One decision in the physical design process is selecting structures.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following threats involves outside parties using information to embarrass a company?

Accepted Answer

A)  Accidental loss 
B)  Theft and fraud 
C)  Loss of confidentiality 
D)  Loss of data integrity 
A)  Accidental loss 
B)  Theft and fraud 
C)  Loss of confidentiality 
D)  Loss of data integrity

Question 6

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 7

Sarbanes-Oxley Act was enacted to ensure the integrity of:

Accepted Answer

A)  SQL. 
B)  public companies' financial statements. 
C)  private companies' shareholders meetings. 
D)  Entity-Relationship Diagrams. 
A)  SQL. 
B)  public companies' financial statements. 
C)  private companies' shareholders meetings. 
D)  Entity-Relationship Diagrams.

Question 8

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

Accepted Answer

A) True 
 B)False

Question 9

An advantage of partitioning is:

Accepted Answer

A)  efficiency. 
B)  remote optimization. 
C)  extra space and update time. 
D)  increase redundancy. 
A)  efficiency. 
B)  remote optimization. 
C)  extra space and update time. 
D)  increase redundancy.

Question 10

An audit trail of transactions and database changes is kept by a journalizing facility.

Accepted Answer

A) True 
 B)False

Question 11

While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the:

Accepted Answer

A)  user. 
B)  CEO. 
C)  XML. 
D)  operating system. 
A)  user. 
B)  CEO. 
C)  XML. 
D)  operating system.

Question 12

A method for handling missing data is to:

Accepted Answer

A)  substitute with random numbers for the missing data. 
B)  track missing data with special reports. 
C)  perform insensitivity testing. 
D)  delete the associated row. 
A)  substitute with random numbers for the missing data. 
B)  track missing data with special reports. 
C)  perform insensitivity testing. 
D)  delete the associated row.

Question 13

Discuss when it is best to use indexes.

Accepted Answer

One should always specify a primary key

Question 14

With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

Accepted Answer

A) True 
 B)False

Question 15

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 16

List the seven factors to consider when choosing a file organization for a particular file in a database.

Accepted Answer

The seven factors are:
1. Fast data retr

Question 17

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 18

A range control limits the set of permissible values that a field may assume.

Accepted Answer

A) True 
 B)False

Question 19

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 20

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

Accepted Answer

A) True 
 B)False

In order to perform a restore/rerun, the database must be mirrored.

Which type of file is most efficient with storage space?

A domain is a way to create a structure that acts like a table.

One decision in the physical design process is selecting structures.

Which of the following threats involves outside parties using information to embarrass a company?

Which type of file is easiest to update?

Sarbanes-Oxley Act was enacted to ensure the integrity of:

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

An advantage of partitioning is:

An audit trail of transactions and database changes is kept by a journalizing facility.

While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the:

A method for handling missing data is to:

Discuss when it is best to use indexes.

With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

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

List the seven factors to consider when choosing a file organization for a particular file in a database.

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

A range control limits the set of permissible values that a field may assume.

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

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

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

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 8: Physical Database Design and Database Infrastructure

In order to perform a restore/rerun, the database must be mirrored.

Which type of file is most efficient with storage space?

A domain is a way to create a structure that acts like a table.

One decision in the physical design process is selecting structures.

Which of the following threats involves outside parties using information to embarrass a company?

Which type of file is easiest to update?

Sarbanes-Oxley Act was enacted to ensure the integrity of:

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

An advantage of partitioning is:

An audit trail of transactions and database changes is kept by a journalizing facility.

While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the:

A method for handling missing data is to:

Discuss when it is best to use indexes.

With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

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

List the seven factors to consider when choosing a file organization for a particular file in a database.

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

A range control limits the set of permissible values that a field may assume.

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

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

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

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters