Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Which of the following is a transaction?
A)A group of SQL statements consisting of one read and one write operation
B)A group of SQL statements consisting only of read operations
C)A group of SQL statements defining a user-oriented task
D)A group of SQL statements consisting only of write operations
2

The effect of the ROLLBACK command in a transaction is the following:
A)Undo all changes to the database resulting from the execution of the transaction
B)Undo the effects of the last UPDATE command
C)Restore the content of the database to its state at the end of the previous day
D)Make sure that all changes to the database are in effect
3

As the bank audit transaction reads Mary's savings balance, $100, Mary transfers $50 to her checking, making it $250, and the audit transaction completes with the combined value of $350 in both accounts. This is called:
A)An uncommitted dependency
B)An incorrect summary
C)A lost update
D)A data entry error
4

It is possible to detect deadlocks in a database system at the following cost:
A)Query the database with SQL
B)Special hardware devices
C)Slower overall processing
D)It is not possible to detect deadlocks
5

The optimistic approach works well:
A)When there are few hotspots
B)When there are many hotspots
C)During a recovery procedure execution
D)None of the above
6

Force writing:
A)Lets the DBMS decide when writing to disk takes place
B)Lets the DBMS write a buffer containing updated data to disk even if the buffer is not full
C)Lets the DBMS decide when to write the content of the log to disk
D)All of the above
7

The redo operation:
A)Restarts a transaction from scratch
B)Writes new values from the log to the database
C)Writes old values from the log back to the database
D)Force writes all buffers to disk
8

The undo operation:
A)Restarts a transaction from scratch
B)Writes new values from the log to the database
C)Writes old values from the log back to the database
D)Force writes all buffers to disk
9

After the crash of a disk containing the database, which of the following tools will need to be used for recovery?
A)Database backup
B)Log
C)Checkpoint table
D)All of the above
10

Which one of the following isolation levels does not prevent the uncommitted dependency problem?
A)Read committed
B)Read uncommitted
C)Repeatable read
D)Serializable





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 15 > Multiple Choice Quiz