PROD1, PROD2 and PROD3 are three active instances of the PROD database.
Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’;
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’;
Which statement is true?
A.
PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.
B.
PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.
C.
The second statement returns an error because this parameter must be identical for all instances.
D.
PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.
Explanation:
First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for PROD1.
D