PrepAway - Latest Free Exam Questions & Answers

Which of the following describes the disadvantage of executing a set of DML statements outside a transaction?

Which of the following describes the disadvantage of executing a set of DML statements outside a
transaction?

PrepAway - Latest Free Exam Questions & Answers

A.
The DBMS records those operations in the audit logs since they are grouped inside a
transaction.

B.
The DBMS stores the transaction operations so that the client applications can rerun the
transaction more easily.

C.
The DBMS guarantees that all operations are always executed successfully.

D.
The DBMS cannot guarantee that all changes performed by the set of DML are stored, nor that
in case of an error; the changes are undone, leaving the database in a inconsistent state.

Explanation:

Topic 3, Volume C


Leave a Reply