Identify the technique through which an SQL database ensures that other transactions do not modify a databaseuntil the first transaction succeeds or fails.
a. Redundancy control
b. Access control
c. Concurrency control
d. Integrity control
ANS: C
RATIONALE: SQL databases rely upon concurrency control by locking database records to ensure that other transactions do not modify a database until the first transaction succeeds or fails. As a result, 100 percent ACID (atomicity, consistency, isolation, and durability)-compliant SQL databases can suffer from slow performance.
Computer Science & Information Technology
You might also like to view...
A compact desktop computer that has the system unit integrated into the monitor is a(n) ________
A) hand-held computer B) all-in-one computer C) notebook D) netbook
Computer Science & Information Technology
The ________ feature enables you to preview a formatting change to your selected text
A) Live Preview B) Backstage view C) Mini toolbar D) Print Preview
Computer Science & Information Technology