Re: another OCP question -- help me guys

Hi Prem,

Firstly, thank you for bringing back fond memories of when I used to teach this stuff for Oracle. If we ever meet one day, I'll show you my highlighter penned copy of the notes showing the various errors and inaccuracies (except the Performance Tuning course where I highlighted the correct bits ;)

Just a personal opinion (don't get me started on OCP) but if I were going for a certification classifying me as a "Professional", I would like to display a greater air of confidence in that I know what all this stuff actually means. I mean once you get the certificate, you'll actually be expected to know how to tune a temp tablespace, drop a tablespace, etc, right ... You're heading in the right direction by questioning these questions but knowing the answers to questions is not the same as being able to solve real-life problems which should be the mandatory skill of any so-called certified professional. I guess I'm suggesting that before you pin on the certification badge, you should have the skills to determine the correct answers to these questions yourself.

Now you've gone and got me started on OCP, but hopefully you know what I mean.

Question 1) Answer B - Statement will fail.

You actually proven this yourself and yet you still have doubts? Trust what you *see*, not what you *read*. The cascade constraints clause if used must go at the end of the statement.

Question 2) Answer A and C.

Again, a simple query or describe of these views would do the trick.

I think we can safely say that "Boson" (whatever he/she/it is) is not a very reliable source ...

Good luck with your OCP

Richard

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 07, 2004 9:24 PM

> Hi list , sorry to pester you with questions regarding
> boson OCP questions . i have scheduled for #1Z0-031 exam
> and so desperately need help from this list .
> please bear with me for while . look at the 2 questions below .
>
> -----------------------------------------------------------------
> QUESTION #1
> what happens when you issue the command below .
> drop tablespace testtbs including contents cascade constraints and
> datafiles;
>
> A.the tablespace will be dropped , constraints will be droppped and the
> datafiles will be taken out of the o/s.
>
> B. statement will fail
>
> C.you must drop constraints before issuing this command.
>
> this is what happens when i try on 9.2.0.4 :
> ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE
>
> but boson's choice is A. i wonder how ???
> -----------------------------------------------------------------
> QUESTION #2
> you need to determine how much space has been allocated for a table.
> which view would give you this information ?
>
> A. dba_extents
> B. dba_ts_quotas
> C. dba_segments
>
> my choice is C .
> but boson's choice is A . it says other views cannot give
> the required details .
>
> a metalink doc says that dba_segments.blocks gives the
> total number of blocks allocated to the table.
>
> what will be the choice that you would go for ?
> -----------------------------------------------------------------
>
> so now i have the question whether boson is reliable ?
> how many in this list have used it ?
> or am i missing something : ((
>
> 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).