最新的Oracle Database 19c認證 1z1-084考試題庫

問題1

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

A. recommendations regarding rewriting the SQL statements

B. recommendations regarding the creation of additional indexes

C. recommendations regarding the creation of materialized views

D. recommendations regarding partitioning the tables

E. recommendations regarding the creation of SQL Patches

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題2

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

A. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25

B. Increasing DB_CACHESIZE to 1 G

C. Setting DB_KEEP_CACHE_SIZE to at least 50M

D. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50

E. Setting PARALLEL_DEGREE_POLICYADAPTIVE

F. Setting PARALLEL_DEGREE_POLICYAUTO

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題3

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?

A. The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.

B. The conflict between the two plan stability methods results in an error.

C. The execution plan is the one enforced by the SQL Profile.

D. The execution plan is the one enforced by the SQL Plan Baseline.

E. The existence of two concurrent plan stability methods generates a child cursor for every execution.

F. The SQL Plan Baseline must be accepted in order to be used for the execution plan.

正確答案: C,F

說明：（僅 VCESoft 成員可見）

問題4

You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

A. TKPROF and Trace Analyzer

B. Autotrace and TKPROF

C. Trcsess and TKPROF

D. Trace Analyzer and Tracsess

正確答案: C

說明：（僅 VCESoft 成員可見）

問題5

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

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

B. 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.

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

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

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

正確答案: D,E

說明：（僅 VCESoft 成員可見）

問題6

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?

A. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.

B. All SGA components retain their current sizes at the time of disabling.

C. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.

D. It requires a database instance restart to take effect.

E. The SGA size remains unaffected after disabling ASMM.

F. All auto-tuned SGA components are reset to their original user-defined values.

正確答案: B,E

說明：（僅 VCESoft 成員可見）

最新的Oracle Database 19c Performance and Tuning Management - 1z1-084免費考試真題

最新更新

站內鏈接

聯系我們