Oracle
1Z0-068 · Question #4
1Z0-068 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-068 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-068 to see the answer
You've previewed enough free 1Z0-068 questions. Unlock 1Z0-068 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.