Quiz
C192 Transaction Management
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (48)
1All transaction properties must display ____
- Aatomicity, serializability, and durability
- Bdurability and isolation
- 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
21Lock ____ indicates the level of lock use.
- Agranularity
- Bshrinking
- Cgrowing
- Dserializability
22During the ____ phase, the transaction scans the database, executes the needed computations, and makes the updates to a private copy of the database values.
- Aread
- Bvalidation
- Cwrite
- Dshared
23During the ____ phase, the changes are permanently applied to the database.
- Aread
- Bvalidation
- Cwrite
- Dshared
24During the ____ phase, the changes are permanently applied to the database.
- Aread
- Bvalidation
- Cwrite
- Dshared
25A(n) ____ backup of the data is when only the last modifications done to the database are copied.
- Adifferential
- Bcomplete
- Cpartial
- Dincomplete
26A transaction that changes the contents of the database must alter the database from one ____ state to another.
- Aconsistent
- Bdependent
- Cindependent
- Dinconsistent
27When is the implicit beginning of a transaction?
- AWhen the database is started
- BWhen a table is accessed for the first time
- CWhen the first SQL statement is encountered
- DWhen the COMMIT command is issued
28A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.
- Agrowing
- Bshrinking
- Clocking
- Dunlocking
29The ____ approach is based on the assumption that the majority of the database operations do not conflict.
- Adefault
- Bbasic
- Cscheduled
- Doptimistic
30A diskpage, or page, is the equivalent of a ____.
- Adatabase table
- Bdisk sector
- Cdatabase schema
- Ddiskblock
31The ____ is responsible for assigning and policing the locks used by the transactions.
- Alock manager
- Bscheduler
- CDBA
- Dtransaction log
32What is a consistent database?
- AOne in which all tables have foreign keys
- BOne in which all data integrity constraints are satisfied
- COne in which all tables are normalized
- DOne in which all SQL statements only update one table at a time
33A transaction acquires a ____ prior to data access.
- Agrain
- Btimestamp
- Clock
- Dkey
34Changes are permanently applied to the database during the ____ phase of a transaction.
- Acommit
- Bwrite
- Cinput
- Doutput
35The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.
- Ascheduled
- Btable-locking
- Cunique
- Dtime-stamping
36All transactions are controlled and executed by the ____ to guarantee database integrity.
- Ascheduler
- BDBMS
- Ctransaction log
- DDBA
37You can define ____ to help the DBMS ensure that the database remains in a consistent state.
- Aintegrity constraints
- Bbusiness rules
- Clock-level transactions
- Dstored procedures
38By its nature, a single-user database system automatically ensures ____ of the database, because only one transaction is executed at a time.
- Aserializability and durability
- Batomicity and isolation
- Cserializability and isolation
- Datomicity and serializability
39The 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.
- Adata dictionary
- Bmetadata
- Crollback manager
- Dtransaction log
40Which of the following is NOT stored in the transaction log?
- AThe type of operation performed
- BA record for the beginning of a transaction
- CThe name of the table
- DThe number of affected records
41What is one of the three most common data integrity and consistency problems?
- ALost updates
- BDisk failures
- CUser errors
- DDeadlocks
42The 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.
- Alost updates
- Buncommitted data
- Ctransaction failure
- Dinconsistent retrieval
43____ occur when a transaction calculates some summary (aggregate) functions over a set of data while other transactions are updating the data.
- ALost updates
- BUncommitted data
- CTransaction failures
- DInconsistent retrievals
44As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
- Ashared
- Bcommon
- Cunrelated
- Dlocked
45The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time.
- Adurability
- Bisolation
- Catomicity
- Dserializability
46What is the most restrictive lock granularity?
- ADatabase
- BTable
- CPage
- DRow
47Which lock granularity has the highest overhead?
- ADatabase
- BTable
- CRow
- DField
48A ____ lock has only two states.
- Ashared
- Bbinary
- Cdatabase
- Drow-level
Information
- Description
- C192 Practice Test
- Author
- Craig Willey
- Language
- English
- Views
- 436
- Tags
- Rating
- No ratings yet Rate this quiz