You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

• A.Taking a new snapshot and comparing it with a preserved snapshot.
• B.Compare Period ADDM report
• C.Active Session History (ASH) report
• D.AWR Compare Period report

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISOR package.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATS package.

Comment: *

Name: *

Email: *

Verification: *

Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure archivelog mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the recovery_catalog_owner role to the recovery catalog schema owner.
6. Grant the sysbackup privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the create catalog command?

• A.1,3,4, 5
• B.2, 4, 5
• C.1,2,4, 5
• D.1,2,3,4, 5,6
• E.2, 4, 5, 6

Comment: *

Name: *

Email: *

Verification: *

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A.Settingthetargettablespacetoread-only
• B.Setting the target tablespace offline
• C.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
• E.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *