: Oracle 1Z0-033
: Oracle 9I
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?
the V$SQL dynamic performance view after
the statement with
the explain plan output
the statement when running with and without
D.compare the statspack output by taking snaps before and after running the statement with the
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
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.
4. In an online transaction processing (OLTP) system, you notice that the transactions are waiting.