DAT 390 Wk 1 – Practice: Knowledge Check

$9.99

DAT 390 Wk 1 – Practice: Knowledge Check

Description

DAT 390 Wk 1 – Practice: Knowledge Check

DAT 390 Wk 1 – Practice: Knowledge Check

A(n) _____ condition occurs when two or more transactions wait for each other to unlock data.

  • binary lock
  • exclusive lock
  • deadlock
  • two-phase lock

 

_____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

  • Isolation
  • Serializability
  • Atomicity
  • Time stamping

 

Time stamps must only have the single property of uniqueness.

  • True
  • False

 

A _____ lock will lock the entire diskpage.

  • table-level
  • transaction-level
  • page-level
  • row-level

 

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

  • True
  • False

 

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.

  • validation
  • read
  • shared
  • write

 

The _____ manager is responsible for assigning and policing the locks used by transactions.

  • transaction
  • lock
  • database
  • schedule

 

Of the following events, which is defined by ANSI as being equivalent to a COMMIT?

  • The program is abnormally terminated.
  • The end of a program is successfully reached.
  • The database is shut down for maintenance.
  • Five SQL statements are executed.

 

The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.

  • True
  • False

 

A _____ lock allows concurrent transactions to access different rows of the same table.

  • page-level
  • table-level
  • database table
  • row-level

 

V081920

DAT 390 Wk 1 – Practice: Knowledge Check