Databases Reference
In-Depth Information
ASSESS YOUR UNDERSTANDING
Go to
www.wiley.com/college/gillenson
to evaluate your knowledge of transac-
tion and locking support.
Measure your learning by comparing pre-test and post-test results.
Summary Questions
1.
Rolling back a transaction reverses all changes made by that transaction.
True or False?
2.
What does the acronym ACID stand for?
(a)
atomicity, concurrency, isolation, and durability
(b)
atomicity, consistency, isolation, and durability
(c)
automation, concurrency, isolation, and durability
(d)
automation, consistency, isolation, and durability
3.
When SQL Server 2005 is operating in implicit transaction mode, which
statement will initiate a new transaction?
(a)
INSERT
(b)
CREATE TABLE
(c)
SELECT
(d)
All of the above
4.
When a database server is configured for autocommit transactions, you
must run either COMMIT TRAN or ROLLBACK TRAN after each
statement. True or False?
5.
Which function returns a list of open transactions?
(a)
@@TRANCOUNT
(b)
@@COUNT
(c)
@@TRANSACTIONS
(d)
none of the above
6.
What happens when you close a connection that has an open
transaction?
(a)
A checkpoint is immediately issued.
(b)
The transaction is committed.
(c)
The transaction is rolled back.
(d)
There is no way to know in advance what will happen.
7.
A dirty page is one that has been updated in memory, but not written to
the hard disk. True or False?
