Which statement is true?

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?

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *