5370 Quiz 8

Ace your homework & exams now with Quizwiz!

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

False

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

False

Indexes are most useful on small, clustered files.

False

Parallel query processing speed is not significantly different from running queries in a non-parallel mode.

False

SOX stands for the Sorbet-Oxford Act.

False

The Number datatype would be appropriate for a zip code.

False

The smallest unit of named application data is a record.

False

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

Hashed

Which type of file is easiest to update?

Hashed

Which of the following is an objective of selecting a data type?

Improve data integrity

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

Public companies' financial statements.

A trigger can be used as a security measure in which of the following ways?

To cause special handling procedures to be executed

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

True

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

True

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

True

In a Heap file organization, files are not stored in any particular order.

True

Keeping the zip code with the city and state in a table is a typical form of denormalization.

True

One decision in the physical design process is selecting structures.

True

Security is one advantage of partitioning.

True

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

True

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

Use a lot of storage space

All of the following are common denormalization opportunities EXCEPT:

a one-to-many relationship.

A transaction that terminates abnormally is called a(n) ________ transaction.

aborted

A method to allow adjacent secondary memory space to contain rows from several tables is called:

clustering.

An advantage of partitioning is:

efficiency

The smallest unit of application data recognized by system software is a:

field.

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

join index.

A method for handling missing data is to:

track missing data with special reports.

Database access frequencies are estimated from:

transaction volumes.

Forward recovery is faster than restore/rerun because:

transactions do not have to be repeated.


Related study sets

CHAPTER 5 - INTRODUCTION TO THE SKELETAL SYSTEM

View Set

AP Human Geography- Unit 6 AP Classroom MCQ

View Set

Mental Health Nursing Chapter 26: Children and Adolescents

View Set

Chapter 1: What are the challenges in ethnographic fieldwork, and how is ethnographic research changing?

View Set

World History Study Guide Review

View Set