최신 1z1-084 무료덤프 - Oracle Database 19c Performance and Tuning Management

문제1

The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?

A. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.

B. Create the RECYCLE cache and cache tables accessed by the SQL statements.

C. Set the CURSOR_SHARING parameter to FORCE.

D. Create the KEEP cache and cache tables accessed by the SQL statements.

E. Increase the size of the library cache.

정답: C,E

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

문제2

Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

A. SQL Execution

B. SQL Transformation

C. SQL Semantic Check

D. SQL Adaptive Execution

E. SQL Row Source Generation

정답: B

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

문제3

You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

A. Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.

B. Disable Automatic Memory Management and set SGA_TARGET to 256G.

C. Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.

D. Set DB_FLASH_CACHE_SIZE parameter to 192G.

E. Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G.

정답: A

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

문제4

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. Database Replay

B. Statspack report

C. SQL Performance Analyzer

D. AWR Compare Periods report

정답: B

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

문제5

During which application lifecycle phase do you take baselines?

A. Deployment

B. Testing

C. Production

D. Migration or upgrade

E. Design and development

정답: C

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

문제6

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

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

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

C. The SGA size remains unaffected after disabling ASMM.

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

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

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

정답: A,C

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

최신 1z1-084 무료덤프 - Oracle Database 19c Performance and Tuning Management

우리와 연락하기

유용한 링크

최신 업데이트