It is more faster and easier to pass the Oracle 1z0-054 exam by using High value Oracle Oracle Database 11g: Performance Tuning questuins and answers. Immediate access to the Up to the immediate present 1z0-054 Exam and find the same core area 1z0-054 questions with professionally verified answers, then PASS your exam with a high score now.

2021 Jul 1z0-054 free exam questions

Q81. View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.

Which two can be inferred from the output? (Choose two.)


A. increase in the number of active sessions

B. unable to grow the database buffer cache as per demand

C. increase in number of COMMITS and ROLLBACKS per second

D. increase in the number of processes waiting for the buffer busy wait event

Answer: AD

Q82. For which two systems would you recommend configuring DBWR I/O slaves instead of multiple database writer processes? (Choose two.)

A. for systems where you have a single CPU

B. for systems where asynchronous I/O is not available

C. for systems with multiple CPUs or multiple processor groups

D. for systems where asynchronous I/O is available and configured

E. for systems where throughput is an important performance consideration

Answer: AB

Q83. Which three statements are true about Statspack usage? (Choose three.)

A. If both Statspack and AWR are used, they cannot be scheduled to capture snapshots at the same time.

B. Time Model data cannot be captured by Statspack unless the STATISTICS_LEVEL parameter is set to ALL.

C. Both Statspack and AWR can be used on the same database only if the Database Diagnostics pack is present.

D. Statspack can be used to generate a report for a specific instance as well as a specific SQL statement in an instance.

E. For best performance when running the performance reports, optimizer statistics should be gathered on the Statspack schema.

Answer: CDE

Q84. You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings:









When you tried to start the database instance with these parameter settings, you received the following error:

SQL> startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

You modified the parameter settings as shown below and the database instance started successfully.









Analyze the parameter settings and identify why the instance failed to start the first time?

A. because the STATISTICS_LEVEL parameter was set to BASIC

B. because the PGA_AGGREGATE_TARGET parameter was set to zero

C. because both the SGA_TARGET and MEMORY_TARGET parameters were set

D. because MEMORY_TARGET and MEMORY_MAX_TARGET parameters were equal

E. because the PROCESSES parameter was set to a value less than the minimum required

Answer: A

Q85. You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events.

View the Exhibit named TOPSQL and note the problems related to these statements.

View the Exhibit named INSTACT and note the table scans.

Which two are appropriate solutions to improve performance? (Choose two.)

A. Enable the large pool.

B. Keep the long tables in the keep buffer pool.

C. Keep the short tables in the keep buffer pool.

D. Set the CACHE property on the table for the long tables.

E. Set the CACHE property on the table for the short tables.

Answer: CE

Far out 1z0-054 test:

Q86. You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET table that contains detailed information about all the products. You gathered the table statistics and executed the following statements to find more information about this table:

SQL> SELECT chain_cnt,

2 round(chain_cnt/num_rows*100,2) pct_chained,

3 avg_row_len, pct_free, pct_used

4 FROM user_tables

5 WHERE table_name = 'PROD_DET'


----------         -----------         -----------    ----------   ----------

4789                           100                  3691               10              40

Which methods can you use to improve the performance? (Choose all that apply.)

A. online table redefinition

B. export and import the table

C. decrease the PCTFREE value

D. move the table using the ALTER TABLE command

Answer: ABD

Q87. You are managing an online transaction processing (OLTP) application database. Some users on the system are reporting degradation in the performance of SQL statements. To diagnose the problem, you want to identify the SQL statements that are expensive on system resources.

What would you recommend to accomplish the task? (Choose all that apply.)

A. running SQL Access Advisor

B. running SQL Performance Analyzer

C. querying the V$SQLSTATS and V$SQL_PLAN views to get the information

D. creating an Automatic Workload Repository (AWR) report for the problematic period

Answer: CD

Q88. You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your database. Many users in the company say that performance has improved on the queries they use, but some users complain that they have not got any performance benefit on the queries they use. You checked all the queries they use and the following is one of them:

SQL> SELECT /*+ RESULT_CACHE */ slnoq.currval as "SLNO", prod_id, pdname, cust_name

FROM sales WHERE sl_date < sysdate;

View the Exhibit and examine the testing performed to check this.

Why is the result cache not used? (Choose all that apply.)


A. because the query uses SYSDATE

B. because the query uses an alias for a column

C. because the query uses the SLNOQ.CURRVAL sequence

D. because the table might have an index on the SL_DATE column

Answer: AC

Q89. You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run hundreds of sessions. Your investigation shows that there is lot of I/O contention happening on only one temporary tablespace and there is no load on other temporary tablespaces. View the Exhibit and examine the details.

After some time you observed that sort operations are running out of temporary space.

What would be a long-term solution?


A. Change the temporary tablespace assigned to this user ID.

B. Create and assign temporary tablespace group to this user ID.

C. Increase the size of the temporary tablespace assigned to this user ID.

D. Make the bigger temporary tablespace the default temporary tablespace ID.

Answer: B

Q90. View the Exhibit and examine a portion of the output obtained from the following query:

SQL> SELECT * FROM v$sys_time_model;

Select three correct interpretations of the time model statistics. (Choose three.)


A. DB time includes the wait time of all the nonidle and idle user sessions.

B. SQL execute elapsed time includes the time spent in performing fetches of query results.

C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.

D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.

E. DB time includes the connection management call elapsed time excluding the background process time.

Answer: BDE