Craig Willey
Quiz by , created more than 1 year ago

C192 Practice Test

373
0
0
Craig Willey
Created by Craig Willey almost 4 years ago
Close

C192 Transaction Management

Question 1 of 48

1

All transaction properties must display ____

Select one of the following:

  • atomicity, serializability, and durability

  • durability and isolation

  • serializability, durability, and isolation

  • atomicity, durability, serializability, and isolation

Explanation

Question 2 of 48

1

A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed

Select one of the following:

  • database-level

  • table-level

  • page-level

  • row-level

Explanation

Question 3 of 48

1

A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.

Select one of the following:

  • database-level

  • table-level

  • page-level

  • row-level

Explanation

Question 4 of 48

1

A ____ lock locks the entire diskpage.

Select one of the following:

  • transaction-level

  • table-level

  • page-level

  • row-level

Explanation

Question 5 of 48

1

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

Select one of the following:

  • database-level

  • table-level

  • page-level

  • row-level

Explanation

Question 6 of 48

1

A(n) ____ lock has only two stages (0 & 1).

Select one of the following:

  • shared

  • exclusive

  • binary

  • two-phase

Explanation

Question 7 of 48

1

A(n) ____ specifically reserves access to the transaction that locked the object.

Select one of the following:

  • shared lock

  • exclusive lock

  • binary lock

  • deadlock

Explanation

Question 8 of 48

1

A(n) ____ lock exists when concurrent transactions are granted read access on the basis of a common lock.

Select one of the following:

  • shared

  • exclusive

  • binary

  • two-phase

Explanation

Question 9 of 48

1

A(n) ____ lock defines how transactions acquire and relinquish locks.

Select one of the following:

  • shared

  • exclusive

  • binary

  • two-phase

Explanation

Question 10 of 48

1

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

Select one of the following:

  • deadlock

  • exclusive lock

  • binary lock

  • two-phase lock

Explanation

Question 11 of 48

1

Which of the following rules applies to the two-phase locking protocol?

Select one of the following:

  • Two transactions cannot have conflicting locks.

  • No unlock operation can precede a lock operation in a different transaction.

  • No data is affected until all locks are released.

  • No data is affected until the transaction is in its locked position.

Explanation

Question 12 of 48

1

____ control is the management of concurrent transaction execution.

Select one of the following:

  • Concurrency

  • Lock

  • Transaction

  • Database

Explanation

Question 13 of 48

1

The most common algorithms for concurrency control are locks, ____ stamping, and optimistic methods.

Select one of the following:

  • date

  • time

  • hour

  • minute

Explanation

Question 14 of 48

1

____ requires that all operations of a transaction be completed.

Select one of the following:

  • Specificity

  • Atomicity

  • Durability

  • Time stamping

Explanation

Question 15 of 48

1

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

Select one of the following:

  • Serializability

  • Atomicity

  • Isolation

  • Time stamping

Explanation

Question 16 of 48

1

When you read from and/or write to a database, you have created a(n) ____.

Select one of the following:

  • transaction

  • back up

  • update

  • queue

Explanation

Question 17 of 48

1

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

Select one of the following:

  • timed

  • practical

  • logical

  • physical

Explanation

Question 18 of 48

1

The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____ and ROLLBACK.

Select one of the following:

  • RETRIEVE

  • ASSIGN

  • UPDATE

  • COMMIT

Explanation

Question 19 of 48

1

The ____ establishes the order in which the operations within concurrent transactions are executed.

Select one of the following:

  • transaction log

  • timer

  • lock manager

  • scheduler

Explanation

Question 20 of 48

1

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

Select one of the following:

  • transaction

  • database

  • lock

  • schedule

Explanation

Question 21 of 48

1

Lock ____ indicates the level of lock use.

Select one of the following:

  • granularity

  • shrinking

  • growing

  • serializability

Explanation

Question 22 of 48

1

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

Select one of the following:

  • read

  • validation

  • write

  • shared

Explanation

Question 23 of 48

1

During the ____ phase, the changes are permanently applied to the database.

Select one of the following:

  • read

  • validation

  • write

  • shared

Explanation

Question 24 of 48

1

During the ____ phase, the changes are permanently applied to the database.

Select one of the following:

  • read

  • validation

  • write

  • shared

Explanation

Question 25 of 48

1

A(n) ____ backup of the data is when only the last modifications done to the database are copied.

Select one of the following:

  • differential

  • complete

  • partial

  • incomplete

Explanation

Question 26 of 48

1

A transaction that changes the contents of the database must alter the database from one ____ state to another.

Select one of the following:

  • consistent

  • dependent

  • independent

  • inconsistent

Explanation

Question 27 of 48

1

When is the implicit beginning of a transaction?

Select one of the following:

  • When the database is started

  • When a table is accessed for the first time

  • When the first SQL statement is encountered

  • When the COMMIT command is issued

Explanation

Question 28 of 48

1

A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.

Select one of the following:

  • growing

  • shrinking

  • locking

  • unlocking

Explanation

Question 29 of 48

1

The ____ approach is based on the assumption that the majority of the database operations do not conflict.

Select one of the following:

  • default

  • basic

  • scheduled

  • optimistic

Explanation

Question 30 of 48

1

A diskpage, or page, is the equivalent of a ____.

Select one of the following:

  • database table

  • disk sector

  • database schema

  • diskblock

Explanation

Question 31 of 48

1

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

Select one of the following:

  • lock manager

  • scheduler

  • DBA

  • transaction log

Explanation

Question 32 of 48

1

What is a consistent database?

Select one of the following:

  • One in which all tables have foreign keys

  • One in which all data integrity constraints are satisfied

  • One in which all tables are normalized

  • One in which all SQL statements only update one table at a time

Explanation

Question 33 of 48

1

A transaction acquires a ____ prior to data access.

Select one of the following:

  • grain

  • timestamp

  • lock

  • key

Explanation

Question 34 of 48

1

Changes are permanently applied to the database during the ____ phase of a transaction.

Select one of the following:

  • commit

  • write

  • input

  • output

Explanation

Question 35 of 48

1

The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.

Select one of the following:

  • scheduled

  • table-locking

  • unique

  • time-stamping

Explanation

Question 36 of 48

1

All transactions are controlled and executed by the ____ to guarantee database integrity.

Select one of the following:

  • scheduler

  • DBMS

  • transaction log

  • DBA

Explanation

Question 37 of 48

1

You can define ____ to help the DBMS ensure that the database remains in a consistent state.

Select one of the following:

  • integrity constraints

  • business rules

  • lock-level transactions

  • stored procedures

Explanation

Question 38 of 48

1

By its nature, a single-user database system automatically ensures ____ of the database, because only one transaction is executed at a time.

Select one of the following:

  • serializability and durability

  • atomicity and isolation

  • serializability and isolation

  • atomicity and serializability

Explanation

Question 39 of 48

1

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.

Select one of the following:

  • data dictionary

  • metadata

  • rollback manager

  • transaction log

Explanation

Question 40 of 48

1

Which of the following is NOT stored in the transaction log?

Select one of the following:

  • The type of operation performed

  • A record for the beginning of a transaction

  • The name of the table

  • The number of affected records

Explanation

Question 41 of 48

1

What is one of the three most common data integrity and consistency problems?

Select one of the following:

  • Lost updates

  • Disk failures

  • User errors

  • Deadlocks

Explanation

Question 42 of 48

1

The phenomenon of ____ occurs when two transactions, T1 and T2, are executed concurrently and the first transaction (T1) is rolled back after the second transaction (T2) has already accessed the uncommitted data—thus violating the isolation property of transactions.

Select one of the following:

  • lost updates

  • uncommitted data

  • transaction failure

  • inconsistent retrieval

Explanation

Question 43 of 48

1

____ occur when a transaction calculates some summary (aggregate) functions over a set of data while other transactions are updating the data.

Select one of the following:

  • Lost updates

  • Uncommitted data

  • Transaction failures

  • Inconsistent retrievals

Explanation

Question 44 of 48

1

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.

Select one of the following:

  • shared

  • common

  • unrelated

  • locked

Explanation

Question 45 of 48

1

The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time.

Select one of the following:

  • durability

  • isolation

  • atomicity

  • serializability

Explanation

Question 46 of 48

1

What is the most restrictive lock granularity?

Select one of the following:

  • Database

  • Table

  • Page

  • Row

Explanation

Question 47 of 48

1

Which lock granularity has the highest overhead?

Select one of the following:

  • Database

  • Table

  • Row

  • Field

Explanation

Question 48 of 48

1

A ____ lock has only two states.

Select one of the following:

  • shared

  • binary

  • database

  • row-level

Explanation

Previous
Check answer
Next