Hi,
I saw this question on dbascripts.com.Can anyont knows the answer.

Which two dynamic performance views could you join to determine the number of extents being used by an active sort?

A. V$SESSION
B. V$ROLLSTAT
C. V$TRANSACTION
D. V$SORT_USUAGE
E. V$SORT_SEGMENT

And another one is,is a profile can be assigned to roles and profiles also or only to users ?

And is this statement true about loads ?
Direct-Load Inserts are only available when the INSERT INTO SELECT command is used.

Thanks,
kkr