C use performance monitoring tools to gather

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to guarantee that every table is normalized to the third normal form for good relational design. C. Use performance-monitoring tools to gather information about the current workload on the system and again later while testing the application to identify potential bottlenecks within the database. D. Help with the design of the tables used in the application to guarantee that every table is normalized to the third normal form for good relational design, and then de-normalize the tables as necessary to achieve the best performance of the application. Answer: C, D Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 125: A breakable parse lock _____. A. can cause waits B. can cause contention C. is held only by statements in the Library Cache D. is held only by PL/SQL objects in the Library Cache E. is held by statements and PL/SQL objects in the Library Cache Answer: E QUESTION 126: Which three statements correctly describe UTLBSTAT/UTLESTAT and STATSPACK, and the major differences between them? (Choose three.) A. STATSPACK collects more data, including high-resource SQL, than UTLBSTAT/UTLESTAT. B. UTLBSTAT/UTLESTAT produces a report after collecting statistics while STATSPACK allows the report to be generated when desired. C. STATSPACK and UTLBSTAT/UTLESTAT will produce the same per transaction ratios given identical collection criteria and data. D. STATSPACK precalculates many useful ratios, such as cache hit ratios and per transaction and per second statistics, while many of these ratios must be calculated manually when using UTLBSTAT/UTLESTAT. E. STATSPACK is typically used for generating bare minimum statistical reports of database activity between 2 points in time, while UTLBSTAT/UTLESTAT extends the data capture to store all statistics in a database repository, allowing for better baseline setting and offline analysis. Answer: A, B, D QUESTION 127: You want to run the UTLLOCKT script to detect lock contention. Which script must be run prior to running UTLLOCKT? A. CATPROC.sql B. CATLOCK.sql C. CATPERF.sql D. CATBLOCK.sql E. CATBPROC.sql Answer: D Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 128: What are the steps the server process goes through when it needs to access a particular data block into the buffer cache? A. The server process must always read the current version of a data block from the data files into the buffer cache. Once it is there, the server process can access the data block. B. The server process always contacts the DBWR process to read the current version of a data block from the data files into the buffer cache. Once it is there, the server process can access the data block. C. The server process first checks to see if the block is already in the buffer cache using a hash function. If it is already in memory, the server process uses it. If the block is not in memory, the server process reads the data block into the buffer cache. Once it is there, the server process can access the data block. D. The server process first checks if the block is already in th...
View Full Document

Ask a homework question - tutors are online