試験番号: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
TestpassportのOracle Database 12c資格1Z0-064問題集を使用すると、常に高いレベルに到達するための独自の知識を向上させています。
弊社のOracle Certified Expert, Oracle Database 12c: Performance Management and Tuning資格1Z0-064勉強資料は試験の最新バージョンを提供することを要求することもできます。
最新のOracle Database 12c資格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
Tuning the Shared Pool
Using Database Replay
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Using Automatic Memory
Tuning I/O
Using the Database Resource Manager
高精度のOracle Database 12c資格1Z0-064試験資料は試験の教材の不足について非常に明確に知っています。
弊社のOracle Database 12c資格1Z0-064（Oracle Database 12c: Performance Management and Tuning）問題集を使うと、追求する勇気は素晴らしい人生で所有の生活のために準備して幸せと緩和されます。
弊社のOracle Database 12c資格1Z0-064試験材料を使用することを選択した候補者の多くは、一度だけのための1Z0-064認定試験に合格しています。
Oracle Database 12c資格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
試験名称：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
TestpassportのOracle Database 12c資格1Z0-064問題集を使用すると、常に高いレベルに到達するための独自の知識を向上させています。
弊社のOracle Certified Expert, Oracle Database 12c: Performance Management and Tuning資格1Z0-064勉強資料は試験の最新バージョンを提供することを要求することもできます。
最新のOracle Database 12c資格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
Tuning the Shared Pool
Using Database Replay
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Using Automatic Memory
Tuning I/O
Using the Database Resource Manager
高精度のOracle Database 12c資格1Z0-064試験資料は試験の教材の不足について非常に明確に知っています。
弊社のOracle Database 12c資格1Z0-064（Oracle Database 12c: Performance Management and Tuning）問題集を使うと、追求する勇気は素晴らしい人生で所有の生活のために準備して幸せと緩和されます。
弊社のOracle Database 12c資格1Z0-064試験材料を使用することを選択した候補者の多くは、一度だけのための1Z0-064認定試験に合格しています。
Oracle Database 12c資格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