イベント・セミナ�?/span>

1Z0-064問題と解答を安心に利用してください

1Z0-064認定試験の練習と多くの類似点を持っています。
Testpassportの1Z0-064練習問題集は短期間で最小の労力で最大の結果を達成し、問題集を使用することができます。
試験番号:1Z0-064
試験名称: Oracle Database 12c: Performance Management and Tuning
関連資格: Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning
バージョン: Oracle Database 12c
試験料(税抜き): 26600 円
試験時間:150
出題数: 84
合格ライン:62%
出題形式:Multiple Choice
最近のわずかの数年間で、Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning認定1Z0-064（Oracle Database 12c: Performance Management and Tuning）試験は日常生活でますます大きな影響をもたらすようになりました。
1Z0-064試験範囲：
Basic Tuning Diagnostics
Using Automatic Workload Repository
Using Metrics and Alerts
Using Baselines
Using AWR-Based Tools
Monitoring Real-Time Database Operation
Monitoring Applications
Identifying Problem SQL Statements
Influencing the Optimizer
Reducing the Cost of SQL Operations
Using SQL Performance Analyzer
SQL Performance Management
Using Database Replay
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Tuning I/O
Using the Database Resource Manager

1Z0-064試験トレーニング資料を利用すればいいです。
最も良い1Z0-064試験資料を見つけました、1Z0-064問題と解答を安心に利用してください。

1.You have been asked to use table compression for two large tables.
Given are the details of the tables:
The TRANS_DET table:
- The table is used by an OLTP application.
- High volume insert and update operations are performed on the table.
- The table is frequently queried using index range scans.
The TRANS_HISTORY table:
- The table is used by a DSS application.
- High volume bulk loads are performed on the table.
- The table is used to store archival data on which large table full-table scans (FTS) are performed.
Which row store compression would you recommend for these tables with minimal overhead on
performance? (Choose the best answer.)
A. basic table compression for both the tables
B. advanced row compression for both the tables
C. basic table compression for the TRANS_HISTORY table and advanced row compression for the
TRANS_DET table
D. basic table compression for the TRANS_DET table and advanced row compression for the
TRANS_HISTORY table
E. warehouse compression for the TRANS_DET table and archive compression for the
TRANS_HISTORY table
Answer: A

2.You want to generate statistics for new objects added to an OLTP application without affecting old
statistics and the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)
A. Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.
B. Set the STALE_PERCENT statistics preference to zero and then gather statistics.
C. Set the PUBLISH statistics preference to FALSE and then gather statistics.
D. Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current
statistics.
E. Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old
statistics.
Answer: A,B

3.Your database supports a DSS workload. In an application, a few complex queries that contain multiple
functions and expressions are using materialized views. You notice that some queries are performing
poorly because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)
A. Create an SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate
recommendations about query rewrite and fast refresh for materialized views.
B. Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
C. Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about
improving the performance of queries.
D. Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting
materialized views.
E. Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query
rewrite with materialized views.
Answer: A,C,E