Multiple choice

What is the necessary condition for the Automatic Transaction Control in Oracle PL/SQL?

  1. The DML commands will be executed automatically by using this control.

  2. SET AUTOCOMMIT; is used to create AUTOCOMMIT environment variable.

  3. To split a long transaction into smaller units by setting some check points.

  4. It is used to manage the changes in the database.

  5. It is used to make the transaction safe.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To execute a COMMIT automatically an INSERT, UPDATE or DELETE command is executed,