Oracle
1Z0-068 · Question #4
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…
The correct answer is D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1. First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for
New Features for Database Infrastructure and Architecture
Question
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?
Options
- APARALLEL_MIN_SERVERS will be 200 for all instances of PROD.
- BPARALLEL_MIN_SERVERS will be 100 for all instances of PROD.
- CThe second statement returns an error because this parameter must be identical for all isntances.
- DPARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.
How the community answered
(23 responses)- A17% (4)
- B4% (1)
- C9% (2)
- D70% (16)
Explanation
First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for
Topics
#ALTER SYSTEM RAC#SCOPE=MEMORY#SID parameter#RAC instance parameters
Community Discussion
No community discussion yet for this question.