183. Which two statements are true regarding Sort Extent Pool? (Choose two.)
A.It is allocated out of the Shared Pool in the SGA.
B.It is allocated out of the default temporary tablespace.
C.It contains the description of all the active sort segments.
D.It contains the list of all queries that used sort segments.
E.It contains the details of the session that is performing sort operations.
ANSWER: AC
184. What provides the information about the free extents in a temporary tablespace before a sort operation?
A.LRU chain
B.sort extent pool
C.resource free list
D.free extent table (FET$)
E.used extent table (UET$)
ANSWER: B
We guarantee your success in the first attempt. If you do not pass the 1z0-033 exam (Oracle9i Database:Performance Tuning) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. TestPassport will help you to pass the 1z0-033 exam. TestPassport 1z0-033 contains 192 questions, multiple choice answers.
Tags:
Post comment:
◎welcome to give out your point。