Quiz
Chapter 10 (MC)
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 (30)
11. A transaction is a ____ unit of work that must be either entirely completed or aborted
- Aa.timed
- Bb.practical
- Cc.logical
- Dd.physical
22. A consistent database is ____.
- Aa.one in which all tables have foreign keys
- Bb.one in which all data integrity constraints are satisfied
- Cc.one in which all tables are normalized
- Dd.one in which all SQL statements only update one table at a time
33.____ requires that all operations of a transaction be completed.
- Aa.Specificity
- Bb.Atomicity
- Cc.Durability
- Dd.Time stamping
44.____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
- Aa.Serializability
- Bb.Atomicity
- Cc.Isolation
- Dd.Time stamping
55. All transactions must display ____.
- Aa.atomicity, consistency, and durability
- Bb.durability and isolation
- Cc.consistency, durability, and isolation
- Dd.atomicity, durability, consistency, and isolation
66. A single-user database system automatically ensures ____ of the database, because only one transaction is executed at a time.
- Aa.serializability and durability
- Bb.atomicity and isolation
- Cc.serializability and isolation
- Dd.atomicity and serializability
77. The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____ and ROLLBACK.
- Aa.RETRIEVE
- Bb.ASSIGN
- Cc.UPDATE
- Dd.COMMIT
88. ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a COMMIT?
- Aa.Five SQL statements are executed.
- Bb.The end of a program is successfully reached.
- Cc.The program is abnormally terminated.
- Dd. The database is shut down for maintenance.
99. ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?
- Aa.Five SQL statements are executed.
- Bb.The end of a program is successfully reached.
- Cc.The program is abnormally terminated.
- Dd.The database is shut down for maintenance.
1010. The implicit beginning of a transaction is ____.
- Aa.when the database is started
- Bb.when a table is accessed for the first time
- Cc.when the first SQL statement is encountered
- Dd.when the COMMIT command is issued
1111. 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.
- Aa.data dictionary
- Bb.metadata
- Cc.rollback manager
- Dd.transaction log
1212. One of the three most common data integrity and consistency problems is ____.
- Aa.lost updates
- Bb.disk failures
- Cc.user errors
- Dd.deadlocks
1313. 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.
- Aa.shared
- Bb.common
- Cc.unrelated
- Dd.locked
1414. A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.
- Aa.database-level
- Bb.table-level
- Cc.page-level
- Dd.row-level
1515.____ are required to prevent another transaction from reading inconsistent data.
- Aa.Locks
- Bb.Schedules
- Cc.Stamps
- Dd.Logs
1616. The ____ manager is responsible for assigning and policing the locks used by the transactions.
- Aa.transaction
- Bb.database
- Cc.lock
- Dd.schedule
1717. Lock ____ indicates the level of lock use.
- Aa.granularity
- Bb.shrinking
- Cc.growing
- Dd.serializability
1818. A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
- Aa.database-level
- Bb.table-level
- Cc.page-level
- Dd.row-level
1919. A ____ lock locks the entire diskpage.
- Aa.transaction-level
- Bb.table-level
- Cc.page-level
- Dd.row-level
2020. A diskpage, or page, is the equivalent of a ____.
- Aa.database table
- Bb.disk sector
- Cc.database schema
- Dd.diskblock
2121. A ____ lock allows concurrent transactions to access different rows of the same table.
- Aa.database-level
- Bb.table-level
- Cc.page-level
- Dd.row-level
2222. A(n) ____ lock has only two stages (0 and 1).
- Aa.shared
- Bb.exclusive
- Cc.binary
- Dd.two-phase
2323. A(n) ____ specifically reserves access to the transaction that locked the object.
- Aa.shared lock
- Bb.exclusive lock
- Cc.binary lock
- Dd.deadlock
2424. A(n) ____ lock exists when concurrent transactions are granted read access on the basis of a common lock.
- Aa.shared
- Bb.exclusive
- Cc.binary
- Dd.two-phase
2525. What is a rule that applies to the two-phase locking protocol?
- Aa.Two transactions cannot have conflicting locks.
- Bb.No unlock operation can precede a lock operation in a different transaction.
- Cc.No data is affected until all locks are released.
- Dd.No data is affected until the transaction is in its locked position.
2626. A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock
- Aa.growing
- Bb.shrinking
- Cc.locking
- Dd.unlocking
2727. A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.
- Aa.deadlock
- Bb.exclusive lock
- Cc.binary lock
- Dd.two-phase lock
2828. The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each trans-action.
- Aa.scheduled
- Bb.table-locking
- Cc.unique
- Dd.timestamping
2929. 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.
- Aa.read
- Bb.validation
- Cc.write
- Dd.shared
3030. In the optimistic approach, during the ____ phase, changes are permanently applied to the database.
- Aa.read
- Bb.validation
- Cc.write
- Dd.shared
Information
- Description
- asdf Quiz on Chapter 10 (MC), created by . . on 07/12/2016.
- Author
- . .
- Language
- English
- Views
- 91
- Tags
- Rating
- No ratings yet Rate this quiz