1Z0-071 practice question 4 of 35
Which two are true about transactions in the Oracle Database?
Full set: 326 questionsIn Oracle Database, a transaction is a sequence of SQL statements processed as a single atomic unit. A Data Definition Language (DDL) statement, such as CREATE TABLE or ALTER TABLE, implicitly commits the current transaction before it executes and commits again after it successfully executes. Therefore, a DDL statement will commit any preceding uncommitted transaction in the same session. Furthermore, the SQLPlus client tool, by default, issues a COMMIT command when a user exits the session normally using the EXIT or QUIT command. This ensures that any uncommitted work is saved.
A. A DDL statement commits the entire preceding transaction in the session, not just the data dictionary updates related to the DDL itself.
D. The first DML statement after a COMMIT or ROLLBACK begins a transaction. Subsequent DML statements are part of the same transaction, they do not start new ones.
E. Oracle's read consistency model ensures that a session cannot see uncommitted changes made in any other session, even if initiated by the same user.
1. Oracle Database Concepts, 23c. "Autonomous Transactions". It states, "DDL statements are preceded and followed by an implicit COMMIT."
2. Oracle Database SQLPlus User's Guide and Reference, 23c. "EXIT Command". The documentation specifies, "By default, EXIT performs a COMMIT."
3. Oracle Database Concepts, 23c. "Overview of Transactions". It explains, "A transaction begins when the first executable SQL statement is encountered... A transaction ends when it is committed or rolled back, either explicitly with a COMMIT or ROLLBACK statement or implicitly when a DDL statement is issued."
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
- Question 11You have the privileges to create any type of synonym. Which stalement will create a syno…
