Multiple choice

Which of the following statements is/are correct about 'WRITE clause' in PL/SQL COMMIT statement?

  1. It is used to specify the priority that the redo information for the committed transaction is to be written to the redo log.

  2. It is used to force the commit of a transaction that may be corrupt or in doubt.

  3. It is used to specify a comment to be associated with current transaction.

  4. This clause is optional.

  5. Both (1) and (4)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are correct statements about 'WRITE clause' in PL/SQL COMMIT statement.

Keep practicing — related questions