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

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

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about server-generated alerts?

• A.Stateless alerts can be cleared manually.
• B.Stateful alerts are purged automatically from the alert history after one day.
• C.Stateless alerts are automatically cleared after one day.
• D.Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
• E.Stateless alerts can be purged manually from the alert history.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

• A.Control file backups can be created while connected to the root container.
• B.Archived Redo Log backups can be created while connected to an application root CDB.
• C.Control file backups can be created while connected to a nonroot container.
• D.Online Redo Log backups can be created while connected to the root container.
• E.The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

• A.The statistics_level parameter is set to all when any of the PDBs is reopened.
• B.The statement is ignored because there is no SPFILE for a PDB.
• C.The statistics_level parameter is set to all when the root database is restarted.
• D.The statistics_level parameter is set to all only for PDB2 when it is reopened.

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• B.All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• C.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
• D.All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• E.These backups can be written to disk or SBT.

Comment: *

Name: *

Email: *

Verification: *