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. Up to 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

The FAST_START_PARALLEL_ROLLBACK parameter in Oracle can only be set to FALSE, LOW, or HIGH - not a numeric value. Setting it to 5 is invalid syntax, so Oracle ignores this setting and uses the default behavior. The numeric options A and B are incorrect because numeric values are not valid for this parameter. Option D is incorrect because RECOVERY_PARALLELISM is a separate parameter unrelated to rollback behavior.

Keep practicing — related questions