Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 18

Which two are true about transactions in the Oracle Database? (Choose two.)

DML statements always start new transactions.

DDL statements automatically commit only data dictionary updates caused by executing the DDL.

A session can see uncommitted updates made by the same user in a different session.

A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.

An uncommitted transaction is automatically committed when the user exits SQL*Plus.

Correct Answer: D, E

A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction because DDL statements in Oracle implicitly commit any pending transactions before they are executed. An uncommitted transaction is automatically committed when the user exits SQL*Plus because exiting SQL*Plus implicitly commits any pending transactions, ensuring that no data is lost.

Discussion

holdfaststronglyOptions: DE

A. DML statements always start new transactions. (X). Not always B. DDL statements automatically commit only data dictionary updates caused by executing the DDL. (X) Not "only" data dictionary C. A session can see uncommitted updates made by the same user in a different session. (X) in the same session D. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction. E. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

dilshod

https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm#BABEGEGC

archit4321Options: DE

The answer is DE

MIGHTYSTUNNERSOptions: BD

bd is correct

presido11111Options: BE

The answer is BE

hmatinnnOptions: DE

should be DE SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits. Any uncommitted data is committed by default.

DiplomiraniZnalac

True hehe