Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OCP question from Boson practice tests
Hi again Prem,
OK, I've changed my opinion of dear Boson. At first I simply thought they had no idea, now I suspect it's all a big joke designed to make DBAs have a bit of a giggle on warm summer nights ...
Sizing the temp tablespace by the formula you've given is really quite witty. Perhaps a little on the silly side but I love Monty Python so I liked it.
The correct answer is actually none of the four listed (so I'm really struggling to find two of the buggers).
Thinking about all this a bit more, if Boson's practice questions puts people off doing OCPs, it might not be such a bad thing after all ...
Cheers ;)
Richard
> Hi List, this is the question .
>
> --------------------------------------------------------------------
> You are calculating the proper size for a temporary tablespace .
> Which of the following are two most important factors to consider ?
>
> A. users
> B. sort_area_size
> C. type of tablespace management
> D. db_block_size
> --------------------------------------------------------------------
>
> my choice is A & B .
>
> but boson's choice is B & D . the explanation given by boson is :
> when sizing a temporary tablespace , the formula is
> db_block_size * sort_area_size .
>
> is it so ? do we need not take no. of users into account ?
> kindly explain me .
>
> Regards,
> Prem.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: richard.foote_at_bigpond.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jan 07 2004 - 07:14:31 CST
![]() |
![]() |