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

문제1

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

A. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

B. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

C. Partition index IX_SALES_TIME_ID using hash partitioning.

D. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.

정답: B

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

문제2

For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance?

A. database consolidation for pluggable databases (PDBs)

B. operating system upgrades

C. operating system and hardware migrations

D. changes to database initialization parameters

E. storage, network, and interconnect changes

정답: A,D

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

문제3

You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

A. In the current working directory

B. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

C. By viewing V$SERVICE_STATS

D. By viewing V$SERV_MOD_ACT_STATS

정답: D

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

문제4

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

A. With a target of 700 MB or more, all multipass executions work areas would be eliminated.

B. PGAA_AGGREGATE should be set to at least 800 MB.

C. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

D. GGREGATE_TARGET should be set to at least 700 MB.

정답: A

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

문제5

Examine this statement and output:

Which two situations can trigger this error?

A. The syntax is incomplete.

B. The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.

C. There is a file in the capture directory.

D. The capture directory is part of the root file system.

E. The instance is unable to access the capture directory.

정답: B,E

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

문제6

You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement's current execution plan:

What must you do to reduce the execution time and why?

A. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

B. Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.

C. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

D. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

E. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

정답: E

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

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

우리와 연락하기

유용한 링크

최신 업데이트