With the aid of Actualtests 1z0-054 puts, you can aquire a good result merely that make an individual pass Oracle test. Moreover, should you unsuccessful within the 1z0-054 examination for the first time of utilizing our items, all money you pay will be refund. You simply need to deliver the 1z0-054 record transcript because any pdf file to all of us. After confirming your data, well refund the amount of money as well as send it back in your accounts as soon as possible.

2016 Jun 1z0-054 test questions

Q41. View the Exhibit and examine portions of two ASH reports generated for the same time period. The second report was generated after the ASH data is flushed to disk.

Why is the sample count reduced in the second report?

Exhibit:


A. because the AWR is not able to store all the samples.

B. because the samples have been filtered from ASH buffer.

C. because a portion of the ASH rolling buffer has been overwritten.

D. because the shared pool size is not enough to hold ASH information.

Answer: B


Q42. You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling to connect to the database. Presently, you have a single-node database. The company plans to migrate the database to a RAC environment. Before you move to a RAC environment, you want to test the performance of the SQL statements and the peak workload on the new environment. To accomplish the Database Capture for replay, you identified the peak workload period on the existing system and started the Database Capture.

Which client requests to the database can be captured as part of the workload capture? (Choose all that apply.)

A. flashback query

B. distributed transactions

C. logging in and logging out of sessions

D. all DDL statements having bind variables

E. direct path load of data from external files

Answer: CD


Q43. You have the automatic optimizer statistics gathering enabled for a 24x7 database as part of the automatic maintenance task. Because the automatic optimizer statistics collection runs during maintenance window(in the night), the statistics on tables that are significantly modified throughout the day becomes stale. This leads to poor query performance on these tables and you want to minimize the overhead in statistics collection.

Identify a solution to this problem.

A. Change the STALE_PERCENT preference to zero for the tables.

B. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

C. Set the OPTIMIZER_DYNAMIC_SAMPLING parameter to zero during day time.

D. Gather statistics on the table when the tables have a representative number of rows, and then lock the statistics.

Answer: D


Q44. View the Exhibit and analyze the output of the query.What does the high value for the table fetch continued rows statistics indicate?

Exhibit:


A. chained rows fetched only

B. migrated rows fetched only

C. rows fetched from external tables

D. both chained and migrated rows fetched

E. rows fetched from Index Organized Tables (IOT)

Answer: D


Q45. You are working on an online transaction processing (OLTP) system. The CUST table in the SH schema was populated by direct load and after that it has gone through a lot of updates and deletions. The statistics for the CUST and SALES tables were updated recently.View the Exhibit and examine the query plan.The query is performing a lot of I/O for a query that fetches only 168 rows. To investigate further, you queried the ALL_TABLES view to find out PCTUSED, PCTFREE, and the number of rows in the CUST table, as given below:

SQL> SELECT table_name ,blocks, pct_used, pct_free, num_rows 

FROM all_tables

WHERE table_name = 'CUST'

TABLE_NAME  BLOCKS PCT_USED PCT_FREE NUM_ROWS

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

            CUST      13768                                 80        111060

What would you recommend to reduce the I/O?

Exhibit:


A. reorganizing the table to use fewer blocks

B. rebuilding the index on the CUST_FIRST_NAME column

C. increasing the value for the PCTFREE attribute for the CUST table

D. increasing the value for the PGA_AGGREGATE_TARGET initialization parameter

Answer: A


certifyforall.com

Replace 1z0-054 practice exam:

Q46. The SALES table in your database undergoes frequent changes. While observing the statistics for the table in the middle of the day, you find a change since the last observation. But the information about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY.

Identify the reason for this.

A. The AWR retention time was set to zero.

B. The STATISTICS_LEVEL parameter was set to BASIC.

C. Some of the statistics were collected using the ANALYZE command.

D. There were user-defined statistics that were set by using the DBMS_STATS.SET_TABLE_STATS procedure.

Answer: C


Q47. The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.

What would you suggest to analyze this performance problem for the user?

A. SQL Tuning Advisor

B. SQL Performance Analyzer

C. Active Session History report

D. AWR Compare Periods report

Answer: C


Q48. View the Exhibit and examine the statistics of a SQL statement.

Which two conclusions can you draw from the statistics? (Choose two.)

Exhibit:


A. The SQL statement has high logical I/O.

B. The SQL statement has high CPU usage.

C. The SQL statement has high physical I/O.

D. The SQL statement has long sort operations.

Answer: AB


Q49. 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 is the most appropriate solution?


A. Create indexes on short tables.

B. Use the CACHE hint to access long tables.

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

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

E. Keep the short tables in the recycle buffer pool.

Answer: D


Q50. 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.)

Exhibit:


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.

Answer: BD