choose three Which three are true about unified auditing in full mode?

• A.The unified audit trail is written to a read-only external file.
• B.The unified audit trail is written to a read-only table.
• C.Audit records are created for SYS.
• D.Audit records are created for non-sys users.
• E.Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the SQL Tuning Advisor?

• A.It checks each query being analyzed for missing or stale statistics.
• B.It considers all SQL statements being analyzed by the advisor task as a group.
• C.It prevents performance regressions for SQL statements when changes are made.
• D.It only recommends syntactic changes to SQL statements.
• E.It can recommend semantic changes to SQL statements.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A.ADDM can recommend shrinking the buffer cache.
• B.ADDM can recommend extending the buffer cache.
• C.By default, MMON creates an AWR snapshot every 30 minutes.
• D.ADDM performs its analysis only when a DBA requests it.
• E.By default, AWR snapshots are automatically purged after eight days.
• F.AWR snapshots must be deleted when no longer required by ADDM.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

• A.Test tuned SQL statements one at a time for all statements in the application.
• B.Test the application as a whole using tuned SQL statements.
• C.Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
• D.Identify poorly tuned SQL statements using the SQL Tuning Advisor.
• E.Tune individual SQL statements using the SQL Tuning Advisor.
• F.Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

Comment: *

Name: *

Email: *

Verification: *