Quiz
Transactions
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem Quiz (20)
1All transaction properties must display ____.
- Aatomicity, serializability, and durability
- Bdurability
- Cserializability, durability, and isolation
- Datomicity, durability, serializability, and isolation
2A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.
- Adatabase-level
- Btable-level
- Cpage-level
- Drow-level
3A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
- Adatabase-level
- Btable-level
- Cpage-level
- Drow-level
4A ____ lock locks the entire diskpage.
- Atransaction-level
- Btable-level
- Cpage-level
- Drow-level
5A ____ lock allows concurrent transactions to access different rows of the same table.
- Adatabase-level
- Btable-level
- Cpage-level
- Drow-level
6A(n) ____ lock has only two stages (0 & 1).
- Ashared
- Bexclusive
- Cbinary
- Dtwo-phase
7A(n) ____ specifically reserves access to the transaction that locked the object.
- Ashared lock
- Bexclusive lock
- Cbinary lock
- Ddeadlock
8A(n) ____ lock exists when concurrent transactions are granted read access on the basis of a common lock.
- Ashared
- Bexclusive
- Cbinary
- Dtwo-phase
9A(n) ____ lock defines how transactions acquire and relinquish locks.
- Ashared
- Bexclusive
- Cbinary
- Dtwo-phase
10A(n) ____ condition occurs when two transactions wait for each other to unlock data
- Adeadlock
- Bexclusive lock
- Cbinary lock
- Dtwo-phase lock
11Which of the following rules applies to the two-phase locking protocol?
- ATwo transactions cannot have conflicting locks.
- BNo unlock operation can precede a lock operation in a different transaction.
- CNo data is affected until all locks are released.
- DNo data is affected until the transaction is in its locked position.
12____ control is the management of concurrent transaction execution.
- AConcurrency
- BLock
- CTransaction
- DDatabase
13The most common algorithms for concurrency control are locks, ____ stamping, and optimistic methods.
- Adate
- Btime
- Chour
- Dminute
14____ requires that all operations of a transaction be completed.
- ASpecificity
- BAtomicity
- CDurability
- DTime Stamping
15____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
- ASerializability
- BAtomicity
- CIsolation
- DTime stamping
16When you read from and/or write to a database, you have created a(n) ____
- ATransaction
- BBack up
- CUpdate
- DQueue
17A transaction is a ____ unit of work that must be either entirely completed or aborted.
- ATimed
- BPractical
- CLogical
- DPhysical
18The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____ and ROLLBACK.
- ARETRIEVE
- BASSIGN
- CUPDATE
- DCOMMIT
19The ____ establishes the order in which the operations within concurrent transactions are executed.
- ATransaction Log
- BTimer
- CLock Manager
- DScheduler
20The ____ manager is responsible for assigning and policing the locks used by the transactions.
- ATransaction
- BDatabase
- CLock
- DSchedule
Informationen
- Beschreibung
- Transactions
- Autor
- Brandon Gagon
- Sprache
- English
- Aufrufe
- 73
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz