Multiple choice

A database has several simultaneous long-running insert transactions. The following statement was issued to ensure that multiple server processes are used to roll back uncommitted transactions: ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK = 5; What is the result?

  1. Upto five rollback processes may be activated simultaneously.

  2. The parameter will be ignored because the maximum number of rollback processes is four.

  3. The parameter will be ignored because it is set to an invalid value.

  4. This parameter will be ignored unless the RECOVERY_PARALLELISM parameter is used.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

FAST_START_PARALLEL_ROLLBACK is a boolean parameter accepting only values FALSE, LOW, or HIGH. Setting it to 5 (a numeric value) is invalid and causes Oracle to ignore the parameter. It does not accept numeric values for the number of processes.

Keep practicing — related questions