Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:SQL> ALTER SYSTEM

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:SQL> ALTER SYSTEM

Post by answerhappygod »

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;Which two statements are true about the statistics level parameter? (Choose two.)

A. It is immediately set to all in the SPFILE and the CDB instance.
B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
C. It is immediately set to all only for cd3Sroot.
D. It is immediately set to all in all PDBs where the statistics_level parameter is not set. E. It is set to all for all PDBs only in the SPFILE.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”