Q77 In which three situations does a new transaction always start? (Choose three.)
- (A). when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
- (B). when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
- (C). when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
- (D). when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
- (E). when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
- (F). when issuing a DML statement after a DML statement failed in the same session
Answer: A,D,E