Which three are true about Database Point-in-Time Recovery?

• A.The database must be in mount state when performing Database Point-in-Time Recovery.
• B.The database must be in archivelog mode.
• C.The target point for the recovery must be specified as a time or System Change Number (SCN).
• D.The database must be open resetlogs after Database Point-in-Time Recovery.
• E.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• F.The database must have flashback database on to perform Database Point-in-Time Recovery.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Audit policies In container databases (CDBs)?

• A.A common unified audit policy can be created at the application root level.
• B.All audit records are written to the audit trail in CDB$ROOT
• C.Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.
• D.Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• E.A common unified audit policy can be created at the CDB level.
• F.An application PDB cannot have a local audit policy.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?

• A.It will return an error because creation of a local role is not allowed in CDB$ROOT.
• B.ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
• C.It will return an error because common roles must start with C##.
• D.ROLE1 will be created only in CDB$ROOT.
• E.ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about opatchauto? (Choose three.)

• A.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• B.It must be invoked by a user with root user privileges.
• C.It applies patches in nonrolling mode by default.
• D.Patches are applied via opatchauto.
• E.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• F.Users must always input patch plans to opatchauto.
• G.It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the character sets used in an Oracle database? (Choose two.)

• A.Single-byte character sets always use 8-bit encoding schemes.
• B.Single-byte character sets always use 7-bit encoding schemes.
• C.Unicode enables information from any language to be stored using a single character set.
• D.Multibyte character sets allow more efficient space utilization than single byte character sets.
• E.Single-byte character sets provide better performance than multibyte character sets.
• F.Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

Comment: *

Name: *

Email: *

Verification: *