1Z0-054 Exam Questions

You find that the OS utilization is over 40% in your database server. Examine the following set of performance monitoring-related activities: 1. Investigate the operating system fo...

Which two activities can be identified as common unscalable causes of suboptimal database performance? (Choose two.)

View the Exhibit and examine the Load Profile from the AWR report of a test database. The application must process an average of 10,000 very small transactions per day. The bulk of...

Examine the following query and its output: SQL>SELECT namespace, gets, gethits, gethitratio, pins, pinhits, reloads,invalidations FROM v$librarycache WHERE namespace = 'SQL AREA';...

On examining the Automatic Workload Repository (AWR) report, you find that log file sync appears among the top 5 wait events.On further investigation, you notice that the average t...

During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appears among the top 5 wait events. What does this event indica...

View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database: SQL>SELECT intsize_csec,metric_name,value, metric_unit...

View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output : Which observation about the output is correct?

A user, SCOTT, complains that his database session, SID 249, is extremely slow in processing transactions. You check the ADDM report and do not find any overall database performanc...

View the Exhibit and examine the partial output from the query on the v$file_histogram view: Which statement correctly interprets the output displayed in the Exhibit?

Which statement is correct about server-generated alerts?

View the Exhibit. Examine the query on the v$servicemetric view and the output. You wish to define a service-level threshold based on wall-clock time to monitor the performance of...

You want information in the form of charts for throughput and services that shows baseline values and thresholds for the baseline. How would you achieve this?

Examine the following block: BEGIN DBMS_WORKLOAD_REPOSITORY. DROP_BASELINE (baseline_name => 'peak baseline', cascade => FALSE, dbid => 3310949047); END; Why would you use the FALS...

You want to capture the performance statistics during a system test that is scheduled for the weekend. Which action would help you to automatically capture the performance statisti...

Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline template.

In a database, the values for transactions per second are higher during working hours and lower during nonworking hours. You want to receive alerts in future time periods if the da...

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

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

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

Identify the correct statements about the SYSTEM_MOVING_WINDOW baseline. (Choose two.)

View the Exhibit and note the workload type selected to quickly configure the metric threshold. Which statement describes the result after finishing this quick configuration proces...

View the Exhibit. You decide to select the setting option in the Exhibit to choose a baseline to be displayed in the performance page. What would you achieve if the baseline is sel...

You analyze an Automatic Database Diagnostic Monitor (ADDM) report to identify the component that contributes most to the database time. Which is the correct description of databas...

View the Exhibit and examine the Automatic Database Diagnostic Monitor (ADDM) performance analysis. Identify the correct description of the Impact(%) column in the Exhibit.

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(%) col...

While diagnosing performance problems for a database, you find Buffer Busy wait is the reason from V$ views. But the Automatic Database Diagnostic Monitor (ADDM) report does not re...

View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.Which statement is true about the report?

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

View Exhibit1 and examine a portion of Active Session History(ASH) report. View Exhibit2 to examine the tablespaces. Which action would you suggest after analyzing the output?

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 sampl...

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 Aut...

You are managing an online transaction processing (OLTP) database with multiple applications. The applications support a large number of users and most of the applications execute...

You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database. Which...

Identify situations in which collecting statistics at the service level helps diagnosing performance problems. (Choose all that apply.)

Your database has the HR and Reporting applications. The HR application does most of the transactions on the database and the Reporting application does most of the batch processin...

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 performan...

You created two services HR and FINANCE on a single instance database. These services are used by the middle-tier applications to connect to the database by using connection pools....

A user session executes a query and the plan for the query is shown in the Exhibit as Plan-1. After verifying with the SQL Access advisor, an index is created on the table in the J...

View the Exhibit and examine the plans in the SQL plan baseline.You observe that the last two SELECT statements (outlined in red and blue) are identical, but have two different pla...

View the Exhibit and examine the result of Automatic SQL Tuning for a period. None of the recommended SQL profiles are implemented. What would you do to allow the Automatic SQL Tun...

You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile which can be used by the query subsequently for better execution plan. View the Exhibit. B...

Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?

The steps involved in copying statistics from the source database to the target database are given below in random order: 1)Export the statistics table from the source database and...

Which statement correctly describes the purpose of the REFRESH COMPLETE option when used with materialized view?

View the Exhibit and examine the TKPROF output. While studying the TKPROF output, you find that the number of disk reads is close to the total number of buffers used (query + curre...

You have the following requirements: - Your transaction only queries the table, and requires a consistent set of the table's data for the duration of the transaction. - You can hol...

You are working in a dedicated server environment. You discovered that your database performance is degraded due to a huge number of sort operations that are using the disk space i...

You observed a lot of unused space below the high-water mark for a table. Which three methods could you use to deallocate the unused space? (Choose three.)

Which two statements are correct regarding users in a shared server environment? (Choose two.)