Site MapHelpFeedbackTrue or False Quiz
True or False Quiz
(See related pages)



1

Instead of following the SQL:1999 specification, Oracle uses the keywords BEGIN TRANSACTION to explicitly start a transaction.
A)True
B)False
2

The "C" in the ACID properties of transactions means that Concurrency control is required for simultaneous transactions.
A)True
B)False
3

Durability of a transaction means that once a transaction is successfully completed, changes resulting from it are stored in the database on permanent storage forever.
A)True
B)False
4

Both uncommitted dependency and inconsistent retrieval problems can occur in situations where only one transaction is writing to part of the database.
A)True
B)False
5

Locks can be placed on a record or a table, but not the full database.
A)True
B)False
6

An operating system failure affects all active transactions, while a device failure affects all active transactions plus all committed transactions that have been recorded on the disk that failed.
A)True
B)False
7

The main objective of checkpoints is to reduce the number and duration of database backups.
A)True
B)False
8

Since constraint checking must occur before the end of a transaction, if a larger transaction is divided into a number of smaller transactions it may be difficult to check some important constraints.
A)True
B)False
9

Balancing concurrency control overhead with potential interference problems can be achieved by a selecting an appropriate isolation level for transactions.
A)True
B)False
10

By default, constraints are enforced immediately after each INSERT, UPDATE, and DELETE statement, but this may be overridden by the DBA with a constraint timing clause.
A)True
B)False





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 > True or False Quiz