1Z0-084試験無料問題集（57題）「Oracle Database 19c Performance and Tuning Management 認定」

出題：1

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

A. Statspack report

B. SQL Performance Analyzer

C. Database Replay

D. AWR Compare Periods report

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which three statements are true about using the in Memory (IM) column store?

A. It improves performance for queries joining several tables using bloom filter joins.

B. It does not improve performance for queries using cached results of function evaluations on columns from the same table.

C. It does not improve performance for queries using user-defined virtual column results.

D. It can improve OLTP workload performance by avoiding the use of indexes.

E. It does not require all database data to fit in memory to improve query performance.

F. It does not improve performance for queries that use join groups on columns from different tables.

正解：A,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which two statements are true about space usage in temporary tablespaces?

A. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

B. Temporary tablespaces setting Includes quotas to limit temporary space used by a session for that Temporary tablespace.

C. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.

D. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.

E. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared.

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which two options are part of a Soft Parse operation?

A. Shared Pool Memory Allocation

B. SQL Row Source Generation

C. Semantic Check

D. SQL Optimization

E. Syntax Check

正解：C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

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.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which procedure gathers statistics that are always used in the generation of any execution plan?

A. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

B. DBMS_STATS.GATHER_SYSTEM_STATS

C. DBMS_STATS.GATHER_DATABASE_STATS

D. DBMS_STATS.GATHER_DICTIONARY_STATS

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1Z0-084試験無料問題集「Oracle Database 19c Performance and Tuning Management 認定」