Filters
Question type

Study Flashcards

In the optimistic approach, during the ____ phase, changes are permanently applied to the database.


A) read
B) validation
C) write
D) shared

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

The information stored in the ____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.


A) data dictionary
B) metadata
C) rollback manager
D) transaction log

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Incomplete or improper transactions can have a devastating effect on database integrity.

A) True
B) False

Correct Answer

verifed

verified

In the optimistic approach, during the ____ phase, a transaction scans the database, executes the needed computations, and makes the updates to a private copy of the database values.


A) read
B) validation
C) write
D) shared

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Although the DBMS is designed to recover a database to a previous consistent state (when an interruption prevents the completion of a required set of transactions), the transactions themselves are defined by the end user or programmer and must be ____________________ correct.

Correct Answer

verifed

verified

When using an optimistic approach, during the write phase, the transaction is validated to ensure that the changes made will not affect the integrity and consistency of the database.

A) True
B) False

Correct Answer

verifed

verified

A transaction is a ____ unit of work that must be either entirely completed or aborted.


A) timed
B) practical
C) logical
D) physical

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.


A) shared
B) common
C) unrelated
D) locked

E) A) and C)
F) B) and D)

Correct Answer

verifed

verified

When using an optimistic approach, a transaction reads the database, executes the needed computations, and makes the updates to a private copy of the database values.

A) True
B) False

Correct Answer

verifed

verified

____________________ can take place at any of the following levels: database, table, page, row, or field.

Correct Answer

verifed

verified

Showing 61 - 70 of 70

Related Exams

Show Answer