최신 1z1-417 무료덤프 - Oracle Database Performance and Tuning Essentials 2015

문제1

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

A. Database Replay

B. SQL Tuning Sets

C. Automatic Workload Repository Baselines

D. Optimizer Statistics Comparator

E. Dynamic Baseline Advisor

정답: B

문제2

Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?

A. shut down any running applications prior to collection

B. gather system statistics after a performance issue has been reported

C. gather system statistics for several hours when there is no workload

D. gather system statistics for several hours during normal workload periods

E. lock out user sessions and gather system statistics overnight

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?

A. network I/O

B. use of SGA memory and ability to allocate PGA

C. CPU

D. SGA

E. concurrent sessions

F. ability to use parallel server processes

정답: C,E,F

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

A. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

B. Use aHOLD HINTin the SQL.

C. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.

D. SetAUTO_UPDATE_STATISTICStoFALSE.

정답: C

문제5

Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?

A. An index only needs to be rebuilt for it to be visible again.

B. I/O bottlenecks are easy to spot when invisible indexes are used.

C. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer.

D. After an index becomes invisible, it is no longer maintained during insertsand updates.

E. An invisible index is ignored by the optimizer.

정답: C,E

문제6

SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

A. Partitions

B. V$ performance views

C. Materialized views

D. Hints

E. Tablespaces

F. Indexes

정답: B,E,F

문제7

An advanced fault diagnostic infrastructure introduced as of Oracle Database 11g, assigns an incidentnumber and diagnostic data when a critical error occurs. What is the feature and where does it store that data?

A. Automatic Workload Repository. Data is stored in views inside the Oracle database.

B. Oracle Enterprise Manager. Data is stored in the OEM Repository.

C. Automatic Diagnostic Repository. Data is stored in views inside the Oracle database.

D. Automatic Diagnostic Repository. Data is stored in a file-based repository outside the database.

E. MyOracle Support. Data is stored in Oracle Cloud.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?

A. In memory, active sessions are sampled every second.

B. It accesses database kernel structures indirectly via the buffer cache.

C. It enables you to conduct performance analysis of long-running sessions.

D. It enables you to conduct performance analysis of transient issues.

E. It enables you to look at all database sessions since the database was created.

정답: A,C

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z1-417 무료덤프 - Oracle Database Performance and Tuning Essentials 2015

우리와 연락하기

유용한 링크

최신 업데이트