Free Oracle 1Z0-054 Exam Dumps Questions & Answers

After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)

• A.  Submitting them to SQL Tuning Advisor
• B.  Running Automatic Database Diagnostic Monitor (ADDM)
• C.  Adding them to SQL Plan Baseline
• D.  Running SQL Access Advisor

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.  distributed transactions
• B.  all DDL statements having bind variables
• C.  flashback query
• D.  direct path load of data from external files
• E.  logging in and logging out of sessions

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 applications
and more users will be added. Presently, the database uses normal file system storage. Before
the new applications are added, you want to move the storage to RAID. You are in consultation
with the OS Administrator for finalizing the RAID option for the storage.
You have the following requirements for the database:
1) Less mean time to recover (MTTR)
2) Striped for performance
3) Mirrored for safety
Which RAID option would you recommend?

• A.  RAID level 1 over 0(0+1)
• B.  RAID level 0
• C.  RAID level 1
• D.  RAID level 0 over 1(1+0)

You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database.Which two options describe what these wait events indicate? (Choose two.)

• A.  Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
• B.  Latch:cache buffer LRU chains - indicates excessive block replacement
• C.  Latch:cache buffer LRU chains - indicates insufficient size of application cursor cache
• D.  Latch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is presently being read into the buffer cache by another session

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(%) column in the Exhibit?

• A.  It gives the maximum reduction in database elapsed time if the recommendation is implemented.
• B.  It produces better query plans if the recommendation is implemented.
• C.  It gives the maximum reduction in the number of input/output (I/O) operations.
• D.  It gives the maximum reduction in resource usage if the recommendation is implemented.