Which two are true about changing the LOCAL_UNDO_ENABLEDproperty to false in a CDB? (Choose two.)

• A.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• B.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
• C.After the change, only one undo tablespace can exist in CDB$ROOT.
• D.After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• E.Undo tablespaces existing in PDBs must be dropped before the change.
• F.After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Optimizer Statistics? (Choose two.)

• A.They are ignored by Optimizer if they are stale.
• B.They can be gathered by the DBMS_STATS package.
• C.They are gathered by the SQL Tuning Advisor.
• D.They provide real-time data about schema objects.
• E.By default, they are automatically gathered by a maintenance job.

Comment: *

Name: *

Email: *

Verification: *

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A.SQL statements
• B.database writer performance
• C.general operating system health
• D.database instance memory management and sizes
• E.log writer performance

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?

• A.Only CDB$ROOT and PDB$SEED are upgraded.
• B.Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
• C.It fails because PDB$SEED is in MIGRATE state.
• D.CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
• E.Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
• F.It fails because PDB2 is not in UPGRADE state.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

• A.The root password cannot be specified in a response file.
• B.root.sh can be executed automatically by the Database installer only by using sudo credentials.
• C.orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
• D.root.sh can be executed automatically by the Database installer only if it is provided with root credentials.
• E.The sudo password must be specified in a response file.

Comment: *

Name: *

Email: *

Verification: *