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 can recommend semantic changes to SQL statements.
• E.It considers all SQL statements being analyzed by the advisor task as a group.
• F.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Comment: *

Name: *

Email: *

Verification: *

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.If the password file location changes, then the new location is used automatically by the Oracle Server.
• B.Schema Only accounts can be granted administrator privileges.
• C.All the Oracle-supplied accounts are Schema Only accounts.
• D.Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
• E.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• F.Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Add the FILE_NAME_CONVERTclause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• B.Set the PDB_FILE_NAME_CONVERTparameter and enable OMF.
• C.Set only the PDB_FILE_NAME_CONVERTparameter.
• D.Add the FILE_NAME_CONVERTclause to the statement and enable Oracle Managed Files (OMF)
• E.Enable only OMF.
• F.Add only the CREATE_FILE_DESTclause to the statement.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

• A.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
• B.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• C.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• D.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• E.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• F.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• G.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about RMAN backup sets? (Choose four.)

• A.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• B.A backup piece can belong to only one backup set.
• C.A data file can be split into multiple sections stored in different backup sets.
• D.Blocks from multiple data files can be contained in one backup set,.
• E.A backup set can contain only one backup piece.
• F.Blocks from multiple data files can be contained in one backup piece,
• G.A backup set must be written to disk.
• H.A backup set must be written to media.

Comment: *

Name: *

Email: *

Verification: *