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 isntances.
D.
PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.
D is correct
D is correct
Correct D
Source:
https://docs.oracle.com/database/121/REFRN/GUID-1D7EC131-7B5B-40E5-A0F8-ABC7B4C5B0E8.htm#REFRN10160