RE: A Question asked in OCP Exam..

No Joe,

if this guy tried this for himself we'd never know about the question, half the beauty of this list is people with the imagination to try things like deleting from a 'read only' tablespace. Man, I'd never even have tried that. It takes great initiative to even think about it in the first place

good work alpesh fella

Sam

-----Original Message-----
From: Joseph S. Testa [mailto:teci_at_oracle-dba.com] Sent: Thursday, January 25, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: A Question asked in OCP Exam..

whty dont u try it on a database and then u'll have the answer.

That is one of the best ways to learn. Take some initiative.

joe
Arul kumar wrote:
>
> Hi,
>
> Can anyone answer this question?
>
> Arul.
>
> ------------------------------------------------------------------------
>
> Subject:
> Date: Thu, 25 Jan 2001 10:52:42 +0530
>
> Anybody ready to answer the following question ? ? ? ? ?
>
> In ur database PROD_DATA tablespace ,which is read only tablespace
> ,contains
> PROD table.
>
> Which of the following is true.
>
> A) u can drop the table
> B) U can delete the rows from the table,but can not drop the table.
> C) U can drop the table bbut cannot delete rows from it.
> D) U can Insert,update & delete rows of the Table.
> E) U can truncate the table.
>
> All the best,
>
> Alpesh B Vyas

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: teci_at_oracle-dba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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