Which one of the following is the most appropriate description of transaction management within relational database management systems?

Which one of the following is the most appropriate description of transaction management within relational database management systems?
Group of answer choices
a. Efficiency is more important than anything else
b. Speed is more important than accuracy in terms of processing
c. Performance of DDL is the paramount concern
d. Accuracy is more important than speed in terms of processing
e. Availability and scalability are primary motivations of processing
Flag question: Question 2
Question 21 pts
Which word is represented by the letter “A” in “ACID” properties?
Flag question: Question 3
Question 31 pts
Which word is represented by the letter “C” in “ACID” properties?
Flag question: Question 4
Question 41 pts
Which word is represented by the letter “I” in “ACID” properties?
Flag question: Question 5
Question 51 pts
Which word is represented by the letter “D” in “ACID” properties?
Flag question: Question 6
Question 61 pts
Three transactions are all initiated within a few seconds of each other are are intent on modifying the same set of rows in an ORDER table; one transaction is granted exclusive access to the set of rows it has targeted while the other two transactions are forced to wait until the first has completed its task. Then one of the remaining transactions is granted exclusive access to the set of rows while the third transaction continues to wait its turn. Which principle(s) is/are being enforced?
Group of answer choices
a. Atomicity
b. Consistency
c. Isolation
d. Durability
Flag question: Question 7
Question 71 pts
Four DML statements are bundled together in a single transaction, including one UPDATE, one DELETE, and two INSERT statements. The first statement completes successfully, as does the second. The third statement fails because a parameter is mistyped and the lookup value for a mandatory FK is NULL. This causes the third statement to fail, which in turn causes the first two successful statements to rollback. Which principle(s) is/are being enforced?
Group of answer choices
a. CONSISTENCY on rejecting the NULL value for a mandatory FK
b. ATOMICITY for forcing ALL statements within a single transaction to rollback.
c. All transactions are committed and declared durable as NULL
d. Once a transaction has been declared durable, it is considered consistent
Flag question: Question 8
Question 81 pts
After rolling back the transaction in the second scenario that had four DML statements (Question 7), the next successful transaction has a PK value that “jumps” four numbers (assume auto-increment population for the PK). There is now a gap of “missing” PK values. Which principle(s) is/are being enforced?
Group of answer choices
a. Atomicity
b. Consistency
c. Isolation
d. Durability
Flag question: Question 9
Question 91 pts
A transaction with a single DML statement to UPDATE a birthdate for a single CUSTOMER erroneously has a date value in the future which violates a business rule in the database. The statement and transaction are rejected. Which principle(s) is/are being enforced?
Group of answer choices
a. Atomicity
b. Consistency
c. Isolation
d. Durability
Flag question: Question 10
Question 101 pts
Which of the following are considered “control of flow” language in SQL?
Group of answer choices
a. WITH…OUTPUT
b. WAITFOR
c. WHILE
d. TOP…BOTTOM
e. BEGIN…END
f. PAUSE…STOP
g. BREAK…CONTINUE
h. LEFT…RIGHT
i. SLOW…FAST
j. IF…ELSE
k. TRY…CATCH

Last Completed Projects