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 LOW or HIGH (values are case-insensitive). Setting it to a numeric value like 5 is invalid syntax, causing the parameter to be ignored. Option A is incorrect because rollback processes use the LOW/HIGH logic, not specific process counts. Option B incorrectly states a maximum of four processes. Option D is wrong because RECOVERY_PARALLELISM is a different, unrelated parameter.

Keep practicing — related questions