Question 51:
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?
Answer options:
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.