Which of the following statements about COMMIT and ROLLBACK commands is incorrect?
A) All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back.
B) All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back.
C) A ROLLBACK command will reverse all DML operations performed since the last COMMIT was performed.
D) all of the above
Correct Answer:
Verified
Q82: The _ command can be used to
Q85: When does a COMMIT command implicitly occur?
A)
Q86: If the _ clause of the UPDATE
Q88: A(n)_ lock will prevent any DDL operations
Q89: A lock arising from a SELECT...FOR UPDATE
Q93: A(n) _ in a SQL command instructs
Q93: Which of the following types of locks
Q96: Which of the following is not a
Q115: Contents of the PROMOTION table
Q119: Contents of the PROMOTION table
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents