1Z0-054 Exam Questions

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

View the Exhibit and examine the content of the V$MEMORY_RESIZE_OPS view. Which two conclusions can you draw? (Choose two.)

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

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

View the Exhibit that shows your investigation on degraded performance. What would you do? (Choose all that apply.)

Which statement is true regarding the setting of the PCTFREE value for an index?

Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.

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

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

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

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

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

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

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

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

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

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

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

In which two scenarios would you recommend using RAID level 5 as an option for database storage?(Choose two.)

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

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

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

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

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

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

As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)

Which two statements are valid regarding row migration? (Choose two.)

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

Which two actions could you perform to reduce busy buffer waits caused on segment header blocks? (Choose two.)

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

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

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

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

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

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

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

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

What is the purpose of running the statspack.snap script during the installation of the Statspack package?

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

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

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

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

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

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

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

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

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

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

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

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