Re: A Question asked in OCP Exam..

From: Emine ATES <emineates_at_postmaster.co.uk>
Date: Thu, 25 Jan 2001 09:27:05 +0000
Message-Id: <10752.127445@fatcity.com>

This is a multi-part message in MIME format...

------------=_980414825-21691-0
Content-Type: text/plain
Content-Disposition: inline

Dear Arul,
since the table is read only,you can not delete from or update of its rows, naturally. moreover you can not truncate the table because extent deallocation causes change on the data file of the read only tablespace. However you can drop table because this effects the data dictionary only.

Good luck,
Emine

On Wed, 24 Jan 2001 21:35:21 -0800 Arul kumar <rakumar_at_mahindrabt.com> wrote:
> Hi,
>
> Can anyone answer this question?
>
> Arul.

------------=_980414825-21691-0
Content-Type: message/rfc822
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

X-POP3-Rcpt: rakumar_at_intranet
Return-Path: <alpesh_at_mahindrabt.com>
Received: from mahindrabt.com ([10.5.4.48])

	by intranet.sharda.mahindrabt.com (8.9.3/8.9.3) with ESMTP id KAA25375;
	Thu, 25 Jan 2001 10:50:22 +0530

Message-ID: <3A6FB821.B8024E2A_at_mahindrabt.com> Date: Thu, 25 Jan 2001 10:52:42 +0530
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
X-Mozilla-Status2: 00000000

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.

1. u can drop the table
2. U can delete the rows from the table,but can not drop the table.
3. U can drop the table bbut cannot delete rows from it.
4. U can Insert,update & delete rows of the Table.
5. U can truncate the table.

All the best, Received on Thu Jan 25 2001 - 03:27:05 CST