What is an executable SQL statement?

Options
- Statement that can be executed without errors
- Statement that generates calls to an instance, including DDL statements only.
- Statement that generates calls to an instance including statements only.
- Statement that generates calls to an instance, including DML and DDL statements.

CORRECT ANSWER : Statement that generates calls to an instance, including DML and DDL statements.

Discussion Board
Oracle Transaction

A transaction in Oracle begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL statement that generates calls to an instance, including DML and DDL statements. When a transaction begins, Oracle assigns the transaction to an available undo tablespace to record the rollback entries for the new transaction. A transaction ends when any of the following occurs:
1. A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.
2. A user runs a DDL statement such as CREATE, DROP, RENAME, or ALTER. If the current transaction contains any DML statements, Oracle first commits the transaction, and then runs and commits the DDL statement as a new, single statement transaction.
3. A user disconnects from Oracle. The current transaction is committed.
4. A user process terminates abnormally. The current transaction is rolled back.

Prajakta Pandit 02-17-2017 03:23 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲