Re: A Question asked in OCP Exam..

From: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
Date: Thu, 25 Jan 2001 11:25:59 +0530
Message-Id: <10751.127436@fatcity.com>

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,
Received on Wed Jan 24 2001 - 23:55:59 CST