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.
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