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

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

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

• A.It can be used to clone a CDB.
• B.It can be used to transport data from a PDB to a non-CDB.
• C.It can be used to transport data between PDBs.
• D.It can be used to create a new PDB.
• E.It can be used to transport data from a non-CDB to a PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

• A.It cannot be used to patch Grid Infrastructure homes containing Oracle Restart.
• B.It Is an Oracle Database service.
• C.It cannot be used to upgrade Oracle Database homes.
• D.It can be used to provision applications.
• E.It can be used to provision middleware.

Comment: *

Name: *

Email: *

Verification: *

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

• A.The target database control file is synchronized from the recovery catalog with a full resync at the next backup.
• B.The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.
• C.The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.
• D.The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The AWR data is stored in memory and in t he database.
• B.AWR contains system wide tracing and logging information.
• C.AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• D.All AWR tables belong to the SYSTEM schema.
• E.The snapshots collected by AWR are used by the self-tuning components in the database

Comment: *

Name: *

Email: *

Verification: *