Chapter 8 (Final)

Question 1

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

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

A view can be built to present only the data to which a user requires access.

Answer 3

True

Question 4

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

Answer 4

public companies’ financial statements.

Question 5

Database applications are not very disk intensive.

Answer 5

False

Question 6

All of the following are advantages to cloud-based computing EXCEPT:

Answer 6

ACID support for database as a service.

Question 7

A device to measure or detect fingerprints or signatures is called a(n) ________ device.

Answer 7

biometric

Question 8

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Answer 8

True

Question 9

All of the following are characteristics of cloud technologies EXCEPT:

Answer 9

unlimited bandwidth.

Question 10

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

Answer 10

data integrity

Question 11

With ________, the database itself is lost, destroyed, or cannot be read.

Answer 11

database destruction

Question 12

There are two principal types of authorization tables: one for subjects and one for facts.

Answer 12

False

Question 13

Security is one advantage of partitioning.

Answer 13

True

Question 14

Sensitivity testing involves:

Answer 14

checking to see if missing data will greatly impact results.

Question 15

The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.

Answer 15

False

Question 16

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

Answer 16

True

Question 17

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

Answer 17

operating system.

Question 18

Vertical partitioning means distributing the columns of a table into several separate physical tables.

Answer 18

True

Question 19

A key decision in the physical design process is:

Answer 19

selecting structures.

Question 20

A(n) ________ is a routine that converts a primary key value into a record address.

Answer 20

hashing algorithm

Question 21

The smallest unit of named application data is a record.

Answer 21

False

Question 22

Guidelines for server security should include all of the following EXCEPT:

Answer 22

securing the network between client and server.

Question 23

Broad network access is a characteristic of cloud computing.

Answer 23

True

Question 24

An audit trail of database changes is kept by a:

Answer 24

journalizing facility.

Question 25

Hash partitioning spreads data evenly across partitions independent of any partition key value.

Answer 25

True