Exam
: Oracle 1Z0-033
Title
: Oracle 9I
Database:Performance
Tuning
Version : Demo
1. You create a stored outline and apply it for use. What strategy would you adopt to verify that the stored
outline is being used for a statement?
A.verify
OL$,OL$HINTS,
and
OL$NODES
tables
after
running
the
statement
with
USE_STORED_OUTLINES set
B.examine
the V$SQL dynamic performance view after
running
the statement with
the
USE_STORED_OUTLINES set
C.compare
the explain plan output
for
the statement when running with and without
the
USE_STORED_OUTLINES set
D.compare the statspack output by taking snaps before and after running the statement with the
USE_STORED_OUTLINES set
Answer: C
2. View the Exhibit.
In your database, you find that the fy05q1 table in a dictionary managed tablespace has excess space.
Further, you find that the table consists of three extents. The size of the first extent is 100KB, the second is
200KB, and the third is 300K. The high water mark is in the middle of the second extent, and there is 400KB
of unused space.
You want to release the unused space so that it can be used by other segments. You execute the following
command to achieve this task:
SQL> ALTER TABLE fy05q1 DEALLOCATE UNUSED;
What would this command do?
A.deallocates the third and second extents
B.deallocates the third extent; the second extent remains as it is
C.deallocates the third extent, and the second extent is sized to 100KB
D.returns an error because the unused space is above the high water mark
Answer: C
3. Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a
table that has an associated Bitmap index?
A.Some DML operations re-create the Bitmap index blocks.
B.The Bitmap index is rebuilt automatically after a DML operation.
C.The smallest amount of a bitmap that can be locked is a bitmap segment.
D.Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
Answer: C
4. In an online transaction processing (OLTP) system, you notice that the transactions are waiting.