Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

does implicit commit happen if CREATE TABLE fails with syntax error?

ben-from-canberraDec 27 2023 — edited Dec 27 2023

An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table.

In which three situations does the transaction complete thereby committing the updates? (Choose three.)

  1. when a CREATE TABLE AS SELECT statement is issued in the same session but fails with a syntax error
  2. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
  3. when the session logs out successfully
  4. when a CREATE INDEX statement is executed successfully in the same session
  5. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
  6. when a COMMIT statement is issued by the same user from another session in the same database instance

I know choice 3 and 4 are correct, but what about the third choice? Is it choice 1 or 2?

Does oracle database issue implicit commit if CREATE TABLE AS SELECT statement is issued but fail to execute?

What about choice 2? if user issue commit after DBA issues SHUTDOWN TRANSACTIONAL statement, will it be successful in committing?

Thanks.

source ExamTopics 1Z0-071 Q69
Comments
Post Details
Added on Dec 27 2023
6 comments
1,989 views