Which statement is true in this scenario?

Examine the set of commands given below:


SQL>ALTER SYSTEM SET TRACE_ENABLED=TRUE SCOPE=MEMORY sid=’*’
SQL>ALTER SYSTEM SET TRACE_ENABLED=FALSE SCOFE=MEMORY sid=’RACDB_1′;
Which statement is true in this scenario?
A. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because this parameter must have the same value on all the instances.
B. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE except the RACDB_1 instance, which will have the value FALSE for this parameter.
C. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because the first ALTER statement has higher precedence.
D. All the instances of the RACDB will nave the TRACE_ENABLED parameter with the value FALSE because the second ALTER statement has higher precedence.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.