申し込みから学習開始まで、待ち時間はほぼありません。GoShikenで1Z0-084試験の問題集をご購入いただくと、お支払い完了後すぐにダウンロードでき、Oracle Database 19c Performance and Tuning Managementの対策をその日のうちに始められます。

Oracle 1Z0-084 試験概要:

Oracle 1Z0-084 試験シラバストピック:

1Z0-084受験者からよく寄せられる質問

Oracle Database 19c Performance and Tuning Management 認定 1Z0-084 試験問題：

問題 #1

Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000', DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1', DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

A. A warning alert will be issued when CPU time exceeds 1 minute for each user call.
B. A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.
C. A critical alert will be issued when CPU time exceeds 2 minutes for each user call.
D. A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.

問題 #2

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Compress the SALES table.
B. Increase PCTFREE for the SALES table.
C. Re-create the SALES table.
D. Partition the SALES table.
E. Coalesce all sales table indexes.

問題 #3

Which two statements are true about Data Pump import for objects that used the in Memory (IM) column store in their source database?

A. It must always transports existing INMEMORY attributes.
B. It can generates the INMEMORY clause that matches the table settings at export time.
C. Its INMEM0RY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting.
D. It ignores the IM column store clause of the exporting objects.
E. Its TRANSFORM clause can be used to add the INMEMORV clause to exported tables that lack them.
F. It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.

問題 #4

You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:

There is no index on the CITY_ID column.
Which two options improve the performance?

A. Use a SQL Profile to enforce the appropriate plan.
B. Force the subquery to use dynamic sampling.
C. Activate the adaptive plans.
D. Generate frequency histograms on the CITY__ID column.
E. Create an index on the CITY IP column.

問題 #5

Which three statements are true about server-generated alerts?

A. Their threshold settings can be modified by using DBMS_SERVER_ALERT.
B. They may contain suggestions for correcting the identified problems.
C. They provide notifications but never any suggestions for correcting the identified problems.
D. They can be viewed only from the Cloud Control Database home page.
E. They are logged in the alert log.
F. They are notifications from the Oracle Database Server of an existing or impending problem.

解説：