another OCP question -- help me guys

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Wed, 07 Jan 2004 03:24:24 -0800
Message-ID: <F001.005DBFA1.20040107032424@fatcity.com>

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 ?

1. dba_extents
2. dba_ts_quotas
3. 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).

Received on Wed Jan 07 2004 - 05:24:24 CST