Which three are true about SGA memory management in a multitenant database? (Choose three.)

• A.Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
• B.The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
• C.Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
• D.Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
• E.The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
• F.SGA_MIN_SIZE cannot be set for a PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle dataabse methodology? (Choose two.)

• A.Tuning activities should stop once agreed service levels for performance have been met.
• B.The alert log should be used to find the database and instance areas most in need of tuning.
• C.SQL statements should always be tuned before tuning any file systems.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.Tuning activities should stop once the user is satisfied with performance.
• F.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.It is always possible for RMAN to connect to a pluggable database as a target.
• B.A Virtual Private Catalog used to registera container database can be created in a pluggable database.
• C.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• D.It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• E.A Virtual Private Catalog used to register a container database can be created in a non-container database.
• F.A Virtual Private Catalog used to register a container database must be created in a pluggable database.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• E.It is always possible for RMAN to connect to a pluggable database as a target.
• F.A Virtual Private Catalog used to register a container database can be created in a non-container database.

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

• A.It is enabled for all users having SELECT privilege on SH.SALES.
• B.Only successful queries of SH.SALES are written to the audit trail.
• C.Audit records are always stored in an external audit file.
• D.It is only enabled for user SH.

Comment: *

Name: *

Email: *

Verification: *