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

Ensurepass

QUESTION 1

After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit. What is the significance of the Benefit(%) column in the Exhibit?

 

clip_image002

 

A.

It produces better query plans if the recommendation is implemented.

B.

It gives the maximum reduction in the number of input/output (I/O) operations.

C.

It gives the maximum reduction in resource usage if the recommendation is implemented.

D.

It gives the maximum reduction in database elapsed time if the recommendation is implemented.

 

Correct Answer: D

 

 

QUESTION 2

You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views. You want to investigate the plans for these SQL statements.Which two methods can you use to pull out the execution plan from the library cache for the already executed SQL? (Choose two.)

 

A.

Query V$SQL_PLAN to view the execution plan.

B.

Query DBA_HIST_SQL_PLAN to view the execution plan.

C.

Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate theexecution plan.

D.

Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.

 

Correct Answer: AD

 

 

QUESTION 3

You are working on a database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.

 

clip_image004

 

You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. The following are the related parameter settings:

 

SQL> show parameter sga

 

name TYPE VALUE

 

—————————– ————— —————–

 

lock_sga boolean FALSE

 

pre_page_sga boolean FALSE

 

sga_max_size big integer 300M

 

sga_target big integer 0

 

SQL> show parameter target

 

name TYPE VALUE

 

—————————– ————— —————–

 

…..

 

fast_start_mttr_target integer 0

 

memory_max_target big integer 0

 

memory_target big integer 0

 

pga_aggregate_target big integer 100M

 

sga_target big integer 0

 

You want to balance the memory between the System Global Area (SGA) components within the SGA

 

depending on the workloads. Which two options would solve this problem? (Choose two.)

 

A.

Set the SGA_TARGET parameter to 300M.

B.

Set the SGA_MAX_SIZE parameter to 400M.

C.

Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 400M.

D.

Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 100M.

E.

Set the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZEparameter to 400M.

 

Correct Answer: AC

 

 

QUESTION 4

You generate an AWR Compare Periods Report for two consecutive time periods as a routine activity to monitor your database performance.View the Exhibit and examine the partial details of the Time Model Statistics generated in the report.Which two statements give a correct inference based on the DB Time and DB CPU in the Time Model Statistics? (Choose two.)

 

clip_image006

 

A.

More CPU time was used for background processes in the first time period.

B.

A change to the database configuration reduced the % DB time for transactions.

C.

More of DB Time was consumed by background processes in the first time period.

D.

A reduction in Hard Parse activity resulted in a reduction of DB CPU Time (in seconds).

E.

More transactions were processed in the first time period based on the DB Time values.

 

Correct Answer: BD

 

 

QUESTION 5

You query the V$SYSSTAT view and notice a significantly high value for the redo log space requests statistic.Which three components would you consider for further investigation based on this information? (Choose three.)

 

A.

LGWR

B.

checkpoints

C.

archiver activity

D.

size of the log buffer

E.

size of the redo log files

 

Correct Answer: BCE

QUESTION 6

You plan to use adaptive thresholds as part of the performance tuning activity. You decide toincrease the window size of the default moving window baseline for all metric observations and comparisons in your database. The following error occurs when you try to increase the window size through Enterprise Manager:

 

Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention (1036800) ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line 601 ORA-06512: at line 2

 

Which action would allow you to perform the preceding task successfully?

 

A.

increasing the flashback retention period

B.

increasing the retention period for SQL Management Base

C.

increasing the undo retention period for the database instance

D.

increasing the Automatic Workload Reposit
ory (AWR) retention period

 

Correct Answer: D

 

 

QUESTION 7

View the Exhibit.You decide to quickly configure the adaptive threshold. What would happen to the existing metric thresholds shown in the Exhibit?

 

clip_image008

 

A.

It would be overwritten.

B.

It would remain in effect.

C.

Only the thresholds set with the SYSTEM_MOVING_WINDOW baseline will remain in effect.

D.

Only the thresholds set with baselines other than the SYSTEM_MOVING_WINDOW baseline will remain in effect.

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

QUESTION 8

You want to review a summary of all the wait events in an instance since it started over a month ago.

 

You issued the following query:

 

SQL>SELECT event, total_waits, time_waited, average_wait

 

FROM V$SYSTEM_EVENT

 

ORDER BY time_waited DESC;

 

View the Exhibit and examine a portion of the output from the above query.

 

clip_image010

 

Which events would you consider from the output for further investigation? (Choose all that apply.)

 

A.

log file sync

B.

rdbms ipc message

C.

SQL*Net message from client

D.

log file switch (checkpoint incomplete)

 

Correct Answer: AD

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 9

View the Exhibit that shows your investigation on degraded performance.What would you do? (Choose all that apply.)

 

clip_image012

 

A.

Shri
nk the temporary segment.

B.

Keep the large tables in the KEEP pool.

C.

Use free list groups wherever applicable.

D.

Increase the value set to the PGA_AGGREGATE_TARGET parameter.

E.

Switch the segments to Automatic Segment Space Management (ASSM).

 

Correct Answer: CE

 

 

QUESTION 10

You work as a DBA in ABC Corp. You are working on an online transaction processing (OLTP) database. The database size has grown to 100 GB. The database will support new applications and more users will be added. Presently, the database uses normal file system storage. Before the new applications are added, you want to move the storage to RAID. You are in consultation with the OS Administrator for finalizing the RAID option for the storage.

 

You have the following requirements for the database:

 

1. Less mean time to recover (MTTR)

 

2. Striped for performance

 

3. Mirrored for safety

 

Which RAID option would you recommend?

 

A.

RAID level 0

B.

RAID level 1

C.

RAID level 0 over 1(1+0)

D.

RAID level 1 over 0(0+1)

 

Correct Answer: C

 

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

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

This entry was posted in 1Z0-054 Exam Questions (December) and tagged , , , , , , . Bookmark the permalink.