1z1-064 試験問題を無料オンラインアクセス

You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables.
What is the recommended action to improve performance? (Choose the best answer.)

• A.Enable temporary undo.
• B.Increase the size of the temporary tablespace or make it autoextensible.
• C.Increase the size of the database buffer cache.
• D.Increase the size of the undo tablespace and enable undo retention guarantee.
• E.Enable Automatic Segment Space Management (ASSM) for the undo tablespace.

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.
Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A.Oracle Enterprise Manager Cloud Control
• B.DBA_ALERT_HISTORY
• C.the alert log
• D.DBA_ACTIVE_SESSION_HISTORY
• E.DBA_OUTSTANDING_ALERTS
• F.DBA_THRESHOLDS

Examine the command:
SQL> ALTER SYSTEM SET TEMP_UNDO_ENABLED = TRUE;
Which two statements are true about setting the parameter value to TRUE?

• A.It improves performance because DML and DDL operations performed on temporary tables do not use the database buffer cache and redo log buffer.
• B.It reduces the amount of redo generated for DML operations performed on temporary tables.
• C.It reduces the amount of undo stored in the undo tablespace.
• D.It improves database performance by reducing the overhead on the PGA.

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)

• A.ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.
• B.Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.
• C.ADDM runs in Partial mode to analyze any hung database issues.
• D.Real-Time ADDM is automatically invoked by ADDM at the end of every hour.

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

• A.Use the result cache hint in the queries.
• B.Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.
• C.Configure the KEEP pool and cache the queried tables used in the KEEP pool.
• D.Use bind variables for similar queries instead of literals.
• E.Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.