Which three are true about the SQL Tuning Advisor? (Choose three.)

• A.It checks each query being analyzed for stale statistics.
• B.It checks each query being analyzed for missing statistics.
• C.It only recommends syntactic changes to SQL statements.
• D.It considers all SQL statements being analyzed by the advisor task as a group.
• E.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
• F.It can recommend semantic changes to SQL statements.

Comment: *

Name: *

Email: *

Verification: *

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A.Reduced CPU utilization
• B.Reduced logical I/O
• C.Improved Serial Execution performance
• D.Reduced physical I/O
• E.Reduced virtual memory utilization

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.CDB1 and PDB$SEED only
• C.PDB$SEED, PDB1, and PDB2 only
• D.CDB1, PDB$SEED, PDB1, and PDB2
• E.CDB1, PDB$SEED, and PDB1 only

Comment: *

Name: *

Email: *

Verification: *

Identify three benefits of Unified Auditing.

• A.It guarantees zero-loss auditing.
• B.The audit trail cannot be easily modified because it is read-only.
• C.It automatically audits Recovery Manager (RMAN) events.
• D.It improves overall auditing performance.
• E.Decreased use ofstorage to store audit trail rowsin the database.

Comment: *

Name: *

Email: *

Verification: *