[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 91-100

Ensurepass

QUESTION 91

Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.What would you do to accomplish the task?

 

A.

Assign resource consumer group to jobs while creating the jobs.

B.

Create services for the applications and create jobs by using the DBMS_JOBS PL/SQL package.

C.

Query v$SESSION to gather statistics of the individual sessions for the workload created by the jobs.

D.

Create services for the applications, create job class associated with the service, and then create jobs by using the job classes.

 

Correct Answer: D

 

 

QUESTION 92

You are working as a DBA on an online transaction processing (OLTP) system. This OLTP systems runs on a machine with a single CPU, on which applications primarily perform small random I/Os where each foreground process reads a data block into the buffer cache for updatesand the changed blocks are written in batches by the DBWR process. You noticed the increase in I/O requests queued up against a disk, and an increase in the wait time in queue. What would you recommend to improve the latency of I/O requests?

 

A.

Stripe data across multiple disks.

B.

Increase the size of buffer cache.

C.

Decrease the value of the DBWR_IO_SLAVES parameter.

D.

Increase the value of the DB_WRITER_PROCESSES parameter.

 

Correct Answer: A

 

 

QUESTION 93

You work as a DBA for a company and manage an online transaction processing (OLTP) system. You received complaints about the performance degradation of SQL statements executed by the application that uses this database.View the Exhibit and examine the output of the queries executed to investigate the performance issues.Which two actions can improve performance? (Choose two.)

 

clip_image002

A.

increasing the size of the shared pool

B.

setting the CURSOR_SHARING parameter to EXACT

C.

decreasing the value set for the OPEN_CURSORS parameter

D.

replacing literals with bind variables in SQL statements with the PLAN_HASH_VALUE 1337874392

E.

replacing literals with bind variables in SQL statements with the PLAN_HASH_VALUE 1445457117

 

Correct Answer: AE

 

 

QUESTION 94

View the Exhibit.Which statement is true about applying the threshold setting in the Exhibit.

 

clip_image004

 

A.

The threshold does not depend on any baseline.

B.

The threshold is decided by comparing the warning and threshold values with the LAST_NIGHT baseline.

C.

The threshold is decided by comparing the warning and threshold values with the SYSTEM_MOVING_WINDOW baseline.

D.

The threshold is decided by comparing
the warning and critical values with the baseline set on the performance page.

 

Correct Answer: A

 

 

 

QUESTION 95

You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic Workload Repository (AWR) report generated in the database. The main sections of the AWRreport is shown in the Exhibits.

 

View the Exhibit named DBTIME and note % DB Time.

 

clip_image006

 

View the Exhibit named TIMEMODEL and note what has contributed to % DB Time.

 

clip_image008

 

View the Exhibit named EFFICIENCY and examine the various percentages shown.

 

clip_image010

 

Which option describes the correct understanding of the main problem?

 

A.

The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time, which indicates that the CPU is very slow.

B.

sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the TIMEMODEL Exhibit. This indicates too many soft parses.

C.

hard parse elapsed time has the majority time in parse time elapsed, which is shown in the TIMEMODEL Exhibit. This indicates inadequate database buffer cache.

D.

% Non-Parse CPU: and Soft Parse %: are low in the EFFICIENCY Exhibit, which shows that very few statements are found in the cache. This indicates that there were too many hard parses.

 

Correct Answer: D

 

 

QUESTION 96

Identify two correct statements about the Active Session History (ASH) data. (Choose two.)

 

A.

A part of SGA memory is used to store ASH data as rolling buffer.

B.

The ASH data can be analyzed between any two small time intervals.

C.

All ASH data in memory are flushed to disk by MMON in every 3 seconds.

D.

All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

 

Correct Answer: AB

 

 

QUESTION 97

You are working on an online transaction processing (OLTP) database that runs on a machine having multiple CPUs. The database uses normal file system storage. Examine the following initialization parameters and their respective values for the instance:

 

NAME TYPE VALUE

 

———————————– ———- ———————-

 

dbwr_io_slaves integer 0

 

db_writer_processes integer 1

 

filesystemio_options string NONE

 

disk_asynch_io boolean TRUE

 

The applications perform small, random I/Os in which each foreground process reads a data block into the buffer cache for updates and the changed blocks are written in batches by the DBWR process. You noticed free buffer waits events for your database.

 

To solve the problem, you increased the size of the buffer cache. But after some time, you notice the same event again.Which three possible actions would you recommend? (Choose three.)

 

A.

configuring multiple DBWR processes

B.

decreasing the size of the buffer cache

C.

configuring I/O slaves for the DBWR process

D.

configuring instances to make asynchronous I/O available to DBWR

E.

spread data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem

 

Correct Answer: ADE

 

 

QUESTION 98

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version that contains important SQL statements. You are not sure about the elapsed time that the SQL statements will have in the new system due to the version change of the optimizer. Which tool provides a comparative report with respect to the elapsed time in both versions of the optimizer?

 

A.

SQL Access Advisor

B.

SQL Tuning Advisor (STA)

C.

SQL Performance Analyzer (SPA)

D.

Automatic Workload Repository (AWR) compare period report

 

Correct Answer: C

 

 

QUESTION 99

Your system is upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After running the SQL Performance Analyzer for optimizer version change, you observe performance regression for a few SQL statements. What would you suggest to avoid performance regression for these SQL statements?

 

A.

Include the old plans in the SQL plan baseline.

B.

Use DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE to evolve plans.

C.

Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE.

D.

Increase the value for the OPTIMIZER_DYNAMIC_SAMPLING parameter.

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

 

 

QUESTION 100

View the Exhibit.You want to set the threshold for the number of transactions (per second)metric with the threshold type as significance level. Which baseline would you choose to make the threshold adaptive?

 

clip_image012

 

A.

LAST_NIGHT

B.

THU_SECTION

C.

SYSTEM_MOVING_WINDOW

D.

MONDAY_1_2008-07-15.02:00

 

Correct Answer: C

 

Free VCE & PDF File for Oracle 1Z0-054 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant A
ccess to Free PDF Files: CompTIA | VMware | SAP …