Pass4side Oracle 1Z0-033 <1>

1. You create a stored outline and apply it for use. What strategy would you adopt to verify that the stored outlineis being used for a statement?
A.verify OL$,OL$HINTS, and OL$NODES tables after running the statement with USE_STORED_OUTLINESset
B.examine the V$SQL dynamic performance view after running the statement with theUSE_STORED_OUTLINES set
C.compare the explain plan output for the statement when running with and without theUSE_STORED_OUTLINES set
D.compare the statspack output by taking snaps before and after running the statement with theUSE_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, youfind that the table consists of three extents. The size of the first extent is 100KB, the second is 200KB, and thethird 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 followingcommand 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 tablethat 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. Which twotechniques would you use to determine if it is a locking problem? (Choose two.)
A.query V$SESSION to determine the sessions waiting for locks
B.query V$LOCKED_OBJECT to diagnose the deadlocked sessions
C.execute the utllockt.sql script to find the list of locking and waiting transactions
D.use the catblock.sql script to populate DBA_BLOCKERS and DBA_WAITERS views
E.query the DBA_WAITERS view to determine the sessions that are waiting for a locked resource
Answer:: CE
5. A customer has various dictionary-managed tablespaces with past data. The extents in dictionary-managedtablespaces are not uniformly sized. Newly created tablespaces are locally managed. You want to make all thetablespaces locally managed. What approach would you use to change the dictionary-managed tablespaces tolocally managed tablespaces to get all the performance benefits of local extent management?
A.use only the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure
B.create new locally managed tablespaces and move data from existing dictionary-managed tablespaces to locallymanaged tablespaces
C.use the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure, followed byDBMS_SPACE_ADMIN.TABLESPACE_FIX_SEGMENT_STATES
D.use the ALTER TABLESPACE command to change extent management to local, and then use theDBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure
Answer:: B
From:www.pass4side.cn .Updated: 2008-9-17