Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?

• A.It can be used to create container databases and non-container databases.
• B.It can be used to change the character set of an existing database.
• C.It can be used to convert a non-container database to a container database.
• D.It can be launched from both the command line and the Universal Installer (OUI) interfaces.
• E.It can only be launched from the command line interface.

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: *

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

• A.Tables with not null constraints cannot be recovered.
• B.Tables or table partitions can be recovered only when the database is in mount state.
• C.Tables or table partitions with a foreign key cannot be recovered.
• D.Tables or table partitions can be recovered by using an auxiliary instance only.
• E.Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• B.It provides before and after execution statistics for each SQL statement in the analysis task
• C.It is integrated with the SQL Access Advisor.
• D.It predicts the impact of system changes on SQL workload response time.
• E.SQL statements that were originally run concurrently are run concurrently by SPA.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) snapshots?

• A.They are always created automatically.
• B.They can be retained forever.
• C.They are generated if STATISTICS_LEVEL is set to TYPICAL.
• D.They are always created manually.
• E.They are generated if STATISTICS_LEVEL is set to ALL.
• F.They are generated if STATISTICS_LEVEL is set to BASIC.

Comment: *

Name: *

Email: *

Verification: *