1Z0-054 Exam Questions
212 real 1Z0-054 exam questions with expert-verified answers and explanations. Page 4 of 5.
- Question #151
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...
- Question #152
Which two activities can be identified as common unscalable causes of suboptimal database performance? (Choose two.)
- Question #153
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...
- Question #154
Examine the following query and its output: SQL>SELECT namespace, gets, gethits, gethitratio, pins, pinhits, reloads,invalidations FROM v$librarycache WHERE namespace = 'SQL AREA';...
- Question #155
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...
- Question #156
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...
- Question #157
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...
- Question #158
View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output : Which observation about the output is correct?
- Question #159
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...
- Question #160
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?
- Question #161
Which statement is correct about server-generated alerts?
- Question #162
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...
- Question #163
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?
- Question #164
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...
- Question #165
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...
- Question #166
Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline template.
- Question #167
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...
- Question #168
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...
- Question #170
View the Exhibit.Which statement is true about applying the threshold setting in the Exhibit.
- Question #171
View the Exhibit. You decide to quickly configure the adaptive threshold. What would happen to the existing metric thresholds shown in the Exhibit?
- Question #172
Identify the correct statements about the SYSTEM_MOVING_WINDOW baseline. (Choose two.)
- Question #173
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...
- Question #174
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...
- Question #175
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...
- Question #176
View the Exhibit and examine the Automatic Database Diagnostic Monitor (ADDM) performance analysis. Identify the correct description of the Impact(%) column in the Exhibit.
- Question #177
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...
- Question #178
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...
- Question #179
View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.Which statement is true about the report?
- Question #180
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.)
- Question #181
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?
- Question #182
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...
- Question #183
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...
- Question #184
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...
- Question #185
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...
- Question #186
Identify situations in which collecting statistics at the service level helps diagnosing performance problems. (Choose all that apply.)
- Question #187
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...
- Question #188
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...
- Question #189
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....
- Question #190
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...
- Question #191
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...
- Question #192
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...
- Question #193
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...
- Question #194
Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?
- Question #195
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...
- Question #196
Which statement correctly describes the purpose of the REFRESH COMPLETE option when used with materialized view?
- Question #197
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...
- Question #198
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...
- Question #199
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...
- Question #200
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.)
- Question #201
Which two statements are correct regarding users in a shared server environment? (Choose two.)