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

• A.They can be retained forever.
• B.They are generated if STATISTICS_LEVEL is set to ALL.
• C.They are always created manually.
• D.They are generated if STATISTICS_LEVEL is set to TYPICAL.
• E.They are always created automatically.
• F.They are generated if STATISTICS_LEVEL is set to BASIC.

Comment: *

Name: *

Email: *

Verification: *

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A.BACKUP SPFILE SECTION SIZE 1M;
• B.BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• C.BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
• D.BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E.BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• F.BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• G.BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

Comment: *

Name: *

Email: *

Verification: *

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:

Which two are true? (Choose two.)

• A.oracle will be granted the SYSASM privilege when installing the Oracle Database software.
• B.The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
• C.oracle must be the owner of every Oracle Database installation.
• D.oracle will be an owner of the Oracle Inventory.
• E.oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.Run the Memory Advisor for the Program Global Area.
• B.Run the Memory Advisor for the System Global Area.
• C.Run the SQL Tuning Advisor.
• D.Run the Memory Advisor for the shared pool.
• E.Run the SQL Access Advisor.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Stateful alerts must be created by a DBA after resolving the problem.
• B.Stateless alerts can be purged manually from the alert history.
• C.Stateless alerts can be cleared manually.
• D.Stateless alerts are automatically cleared.
• E.Stateful alerts are purged automatically from the alert history.

Comment: *

Name: *

Email: *

Verification: *