I think the answer is C, because dropping a table is actually updating data
dictionary table in SYS tablespaces (as long as the user has sufficient
privs). But if answer C means dropping a table without deleting its rows
(which is impossible), then the real answer will be A. Truncate is not
permitted in this case. CMIIW
- Original Message -----
From: "Ramamohan B N" <ramamohan.bn_at_tatainfotech.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, January 25, 2001 1:05 PM
Subject: Re: A Question asked in OCP Exam..
> Hi,
>
> I am just reasoning...
> Might be E. Can truncate the table
> Since no redo is generated during that process...
> PLEASE CORRECT ME IF I AM WRONG...!
>
> Regards,
> Mohan
>
> 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
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramamohan B N
> INET: ramamohan.bn_at_tatainfotech.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
> also send the HELP command for other information (like subscribing).
Received on Thu Jan 25 2001 - 04:02:10 CST
