Oracle Exam 1Z0-920 Topic 2 Question 20 Discussion

Actual exam question for Oracle's 1Z0-920 exam

Question #: 20
Topic #: 2

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

ABoth the tables, t1 and t2, are created.

BBoth the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

COnly the t2 table is created.

DOnly the t1 table is created.

Show Suggested Answer

Suggested Answer: A

by Arminda at May 05, 2022, 04:30 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!