The Database Transaction Process

The section contains multiple-choice problems on the concepts of the database transaction process, storage structures, and properties of transactions like atomicity, durability, isolation, and their implementations.

Start Quiz

Multivalued dependencies should __ be eliminated.

Always

Commonly

Seldom

Never

When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the __ step.

First

Second

Third

Fourth

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

The multivalue, multicolumn problem

The inconsistent values problem

The missing values problem

The general-purpose remarks column problem

When the transaction finishes the final statement, the transaction enters into the __ state.

Active state

Committed state

Partially committed state

Abort state

__ means that a second transaction cannot use the data used during the execution of a transaction until the first one is complete.

Consistency

Atomicity

Durability

Isolation

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following forms a transaction?

Only 1

Only 2

Both 1 and 2 individually

Either 1 or 2

Eliminating modification anomalies is __ of normalization.

An advantage

A disadvantage

Either an advantage or disadvantage

Neither an advantage nor disadvantage

__ states that only valid data will be written to the database.

Consistency

Atomicity

Durability

Isolation

The Oracle RDBMS uses the __ statement to declare a new transaction and its properties.

BEGIN

SET TRANSACTION

BEGIN TRANSACTION

COMMIT

Which of the following are characteristics of transactions?

Atomicity

Durability

Isolation

All of the above

The property of a transaction that persists in all the crashes is

Atomicity

Durability

Isolation

All of the above

A transaction is delimited by statements (or function calls) of the form

Begin transaction and end transaction

Start transaction and stop transaction

Get transaction and post transaction

Read transaction and write transaction

Transaction processing is associated with everything below except

Producing detail summary or exception reports

Recording a business activity

Confirming an action or triggering a response

Maintaining a data

Needing to use more complicated SQL in database applications is __ of normalization.

An advantage

A disadvantage

Either an advantage or disadvantage

Neither an advantage nor disadvantage

Which of the following has the ‘all-or-none’ property?

Atomicity

Durability

Isolation

All of the above

Quiz/Test Summary
Title: The Database Transaction Process
Questions: 15
Contributed by:
Ivan