최신 1z1-064 무료덤프 - Oracle Database 12c: Performance Management and Tuning

문제1

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)

A. loading performance data and execution plans from an STS.

B. generating an execution plan and statistics for selective SQL statements captured in an STS

C. generating only execution plans on a test database without actually running SQL statements.

D. executing SQL statements in a SQL Tuning Set (STS) on a test database by using database links to the production database.

E. generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.

정답: B,C,D

문제2

Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

A. Reducing DB time allows a database instance to support more user requests by using the same resources.

B. DB time includes the time spent on client processes and background processes.

C. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.

D. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.

E. DB time is always greater than or equal to the DB CPU time.

정답: A,E

문제3

Examine the parameters set for a database instance supporting a mixed workload:

The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:

Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

A. Increase the size of the large pool.

B. Use a parallel hint in the queries.

C. Increase the value of the SORT_AREA_SIZE initialization parameter.

D. Increase the number of DBWn processes.

E. Increase the size of the temporary tablespace or add a new temporary tablespace.

F. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

정답: A,C

문제4

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert.
What is the outcome? (Choose the best answer.)

A. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.

B. It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.

C. It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.

D. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.

E. It generates an error because the warning threshold cannot exceed 100%.

정답: E

문제5

In which three scenarios would you recommend the use of the SQL Performance Analyzer?

A. to identify SQL statements whose performance may have regressed due to a hardware upgrade

B. to analyze the impact of network and interconnect changes on database workload

C. to identify SQL statements that require SQL profiles

D. to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c

E. to analyze the impact of using bind variables for syntactically similar SQL statements

F. to analyze the impact of new indexes and materialized views on the SQL statements executed by an application

정답: A,B,C

문제6

Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)

A. queries not using indexes and performing full table scans

B. the shared pool is inadequately sized

C. too many sort operations being performed

D. repeated simultaneous access to a block or small number of blocks

E. queries repeatedly fetching blocks that are not in the database buffer cache

F. cursors are closed explicitly after each execution

정답: B,D,E

문제7

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

A. The values for Redo size and Block changes imply that only updates were performed by transactions.

B. The values for SQL Work Area and User calls imply that only sort-based operations were performed.

C. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.

D. The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and consistent gets per second.

E. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.

정답: B,C

문제8

Which two statements are true about wait events?

A. A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.

B. A wait event can be defined in multiple wait classes.

C. Wait events for an instance include statistics for both background and foreground processes.

D. Wait event statistics are cumulatively collected only at the instance level.

E. Wait event countries are incremented by the server process that waits.

정답: B,E

문제9

To diagnose the performance degradation of your production database, you execute these queries:

Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?

A. The buffer cache is undersized.

B. There are too many disk sort operations.

C. Contention is caused by freelist management.

D. The database writer (DBWR) process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.

E. PGA is undersized

정답: D

문제10

In which three situations can dynamic statistics be used? (Choose three.)

A. when a query is on a partitioned table with a global index

B. when extended statistics are not available for SQL statements that use complex predicates

C. when index statistics are missing on a column that is used in SQL statements with highly selective filters

D. when an execution plan is suboptimal because of complex predicates

E. when the sampling time is a small fraction of the total time for a query

정답: A,B,D

최신 1z1-064 무료덤프 - Oracle Database 12c: Performance Management and Tuning

우리와 연락하기

유용한 링크

최신 업데이트