1Z0-054 Exam Questions
212 real 1Z0-054 exam questions with expert-verified answers and explanations. Page 3 of 5.
- Question #101
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: MEMORY_MA...
- Question #102
View the Exhibit and examine the content of the V$MEMORY_RESIZE_OPS view. Which two conclusions can you draw? (Choose two.)
- Question #103
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...
- Question #104
View the Exhibit that shows your investigation of performance degradation in your database. You also know that there are a few tablespaces using automatic segment-space management...
- Question #105
View the Exhibit that shows your investigation on degraded performance. What would you do? (Choose all that apply.)
- Question #106
Which statement is true regarding the setting of the PCTFREE value for an index?
- Question #107
Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.
- Question #108
View the Exhibit and analyze the output of the query. What does the high value for the table fetch continued rows statistics indicate?
- Question #109
You observed in your database that the queries formerly executed in 5 seconds now take longer time. View the Exhibit and analyze the output of the query that you executed to find t...
- Question #110
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 a...
- Question #111
You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database. On further investigation, you find that at the end of each day the contents...
- Question #112
You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wants to upgrade the storage used by the database to faster ha...
- Question #113
You are working as a DBA on an online transaction processing (OLTP) system. This OLTP systems runs on a machine with a single CPU, on which applications primarily perform small ran...
- Question #114
The OS administrator in your company informed you about the upgrade of storage to new disk controllers and hard disks. You want to test if the new I/O devices are capable of handli...
- Question #115
You are working on a single node database. The storage for the database was recently upgraded to new, faster hard disks and new disk controllers. You ran the I/O calibration proced...
- Question #116
View the Exhibit and examine the output for the query on V$IOSTAT_FUNCTION. Which two statements are true about the interpretation of the output? (Choose two.)
- Question #117
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 application...
- Question #118
You are working 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 appl...
- Question #119
In which two scenarios would you recommend using RAID level 5 as an option for database storage?(Choose two.)
- Question #120
You are working on an online transaction processing (OLTP) database that runs on a machine having multiple CPUs. The database uses normal file system storage. Examine the following...
- Question #121
For which two systems would you recommend configuring DBWR I/O slaves instead of multiple database writer processes? (Choose two.)
- Question #122
You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of har...
- Question #123
You are working on the Database using file system RAID level 0 striping. You want to migrate the database files to the Automatic Storage Management (ASM). The applications supporte...
- Question #124
What type of redundancy would you recommend for the Automatic Storage Management (ASM) of a file system based on RAID level 1 for the optimum performance of database using ASM stor...
- Question #125
You look at the Top 5 Timed Events section of the Automatic Workload Repository (AWR) report and find that the wait event buffer busy waits is consuming a significant portion of DB...
- Question #126
As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)
- Question #127
Which two statements are valid regarding row migration? (Choose two.)
- Question #128
While tuning the shared server in your database, you executed the following command: SQL> ALTER SYSTEM SET DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=5)'; How does this statement af...
- Question #129
Which two actions could you perform to reduce busy buffer waits caused on segment header blocks? (Choose two.)
- Question #130
In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance: SQL> SELECT d.value "...
- Question #131
You issued the following query on the V$INSTANCE_RECOVERY dynamic performance view: SELECT target_mttr, estimated_mttr FROM v$instance_recovery; You noticed that the value for the...
- Question #132
View the Exhibit and examine the execution plan of the following query: SQL> SELECT s.prod_id 2 , t.fiscal_month_number 3 , sum(s.amount_sold) AS sum_amount 4 FROM sales s, times t...
- Question #133
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, av...
- Question #134
View the Exhibit and examine the partial output obtained when you issued the following query: SQL> SELECT name,class,value FROM v$sysstat ORDER BY class; Which two interpretations...
- Question #135
As a DBA, you notice a change in the performance of your database. Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Cho...
- Question #136
As a DBA, you notice that the response time of your database has degraded. Which two pieces of tuning-related information can you examine in the alert log to identify possible caus...
- Question #137
The Service-Level Agreement for the production database includes a clause that the database down time should not be more than 15 minutes. Which two details would you examine in the...
- Question #138
What is the purpose of running the statspack.snap script during the installation of the Statspack package?
- Question #139
While configuring the snapshot data capture for your database, you have specified the snapshot level setting as 6. Which statistics would be captured by the Statspack report? (Choo...
- Question #140
Which three statements are true about Statspack usage? (Choose three.)
- Question #141
Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database 11g software.The application workload on your database is known to be stable between...
- Question #142
Your database has the ACCTG service configured for an accounting application that runs on a middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enable...
- Question #143
Your database has the ACCTG service configured for an accounting application running on a middle tier. These service is used by the middle-tier applications to connect to the datab...
- Question #144
You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details. View Exhibit2 to see the details of the SQL text for the statements. W...
- Question #145
View the Exhibit and examine the Instance Efficiency Percentages that you got on generating an Automatic Workload Repository (AWR) report for your online transaction processing (OL...
- Question #146
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 det...
- Question #147
As part of a proactive tuning activity, you have the Automatic Workload Repository (AWR) and ADDM enabled for your database with the default setting of snapshot retention as 8 days...
- Question #148
In your organization the Oracle Database 11g installation includes the Oracle Diagnostic Pack. In your database, the STATISTICS_LEVEL and CONTROL_MANAGEMENT_PACK_ACCESS parameters,...
- Question #149
There are 500 users of an online transaction processing (OLTP) application that resides in your database. The system had been maintaining an average response rate of 10 seconds as...
- Question #150
In your organization, there are two key databases. One of them is used primarily for an online transaction processing (OLTP) application and is directly accessed by the users in a...