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
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
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
You want to run the UTLLOCKT script to detect lock contention. Which script
must be run prior to running UTLLOCKT?
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?
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
- Fall '09
- Oracle Database, Database management system, new features, Oracle9i, OCP Oracle9i Database