2026年にOracle Database 12c: Performance Management and Tuningの取得を目指すなら、教材選びから更新サポートまで一貫したCertShikenのサービスが便利です。1z1-064の無料サンプル確認から120問の本格演習、365日間の無料更新まで、合格への道筋をワンストップで用意しています。

Oracle 1z1-064 試験概要:

認定ベンダー:	Oracle
試験名:	Oracle Database 12c: Performance Management and Tuning
試験番号:	1Z0-064
試験形式:	複数選択式, 単一選択式
関連資格:	Oracle Database 12c Administrator Certified Professional
認定の有効期間:	Oracle認定資格の有効期限は異なります。多くのDatabase 12c認定資格は歴史的に有効期限がありませんが、ポリシーはトラックによって異なる場合があります。
受験料:	245米ドル（地域によって異なる場合があります）
試験時間:	120 分
対応言語:	英語
合格点:	約60%
出題数:	約60-80問
推奨トレーニング:	Oracle Database パフォーマンスチューニングコース Oracle University - Database 12c トレーニング
受験申し込み:	Pearson VUE Oracle試験 Oracle認定資格の登録
サンプル問題:
受験方法:	Pearson VUEテストセンターまたはオンライン監督付き試験によるコンピュータベースの試験（地域によって利用可能状況が異なります）
前提条件:	推奨：Oracle Database 12c Administrator Certified Professional（通常は1Z0-062および1Z0-063を含む）または同等のOracle DBA経験
公式シラバスのURL:	https://education.oracle.com/oracle-certification-exams

Oracle 1z1-064 試験シラバストピック:

1z1-064受験前に知っておきたいQ&A

Oracle Database 12c: Performance Management and Tuning 認定 1z1-064 試験問題：

問題 #1

You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)

A. Automatic Workload Repository (AWR) compare periods report
B. SQL Performance Analyzer
C. SQL Access Advisor
D. Automatic Database Diagnostic Monitor (ADDM) compare periods report
E. Database Replay
F. SQL Tuning Advisor

問題 #2

Your database supports an OLTP system.
Examine the parameter values configured in your database:
sga_max_size = 480M
sga_target = 480M
pga_aggregate_target = 160M
The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS');
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform a series of INSERT, UPDATE, and DELETE operations on the table.
View the Exhibit to examine the query and its execution plan.

Which two options can improve the performance of the query without significantly slowing down the DML operations? (Choose two.)

A. regathering statistics on the CUSTOMERS table
B. creating a histogram on the COUNTRY_ID column
C. creating a bitmap index on the COUNTRY_ID column
D. creating a KEEP cache
E. gathering statistics on the COUNTRY_IDX index
F. creating a SQL profile
G. increasing the size of the PGA

問題 #3

A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay.
What three could be reasons for this change? (Choose three.)

A. to reduce the time of replay
B. to increase the number of concurrent users during replay
C. to reduce the elapsed time between two successive user calls from a session.
D. to decrease the wait for a query, caused by noncommitted transactions
E. to decrease the number of concurrent users during replay

問題 #4

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. the alert log
C. DBA_ALERT_HISTORY
D. DBA_OUTSTANDING_ALERTS
E. DBA_ACTIVE_SESSION_HISTORY
F. DBA_THRESHOLDS

問題 #5

Examine the structure of the EMPLOYEES table.

EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.

Which two actions should you perform to make the cursor bind aware? (Choose two.)

A. Create a histogram on the DEPARTMENT_ID column.
B. Change the default CURSOR_SHARING value to FORCE.
C. Execute the query with the same DEPARTMENT_ID value multiple times.
D. Gather statistics for the index.
E. Create an index on the DEPARTMENT_ID column.
F. Regather statistics on the table.

解説：