SQL - if we truncate a table which consists of 100 rows then how many rows get updated?

GeekInterview.com > Placement Papers > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 31 of 32

if we truncate a table which consists of 100 rows then how many rows get updated?

Total Answers and Comments: 11

Last Update: June 14, 2008 Asked by: srinivasakumar.ch

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

March 24, 2006 11:15:37

srinivasakumar

RE: if we truncate a table which consists of 100 rows ...

Is this answer useful? Yes | No

April 22, 2006 05:47:38

Ram Kumar

RE: if we truncate a table which consists of 100 rows ...

Tuncate command will delete the rows not updated the rows and it it is DDl

commnad. Therefore any row will not get updated.

Is this answer useful? Yes | No

June 10, 2006 10:28:07

Sajid Belvadi

RE: if we truncate a table which consists of 100 rows ...

truncate will remove all the table data without affecting the table structure. that means all the 100 rows get updated. but before truncating see if it contains any constraint.

Is this answer useful? Yes | No

July 10, 2006 07:11:48

VijayaKumar

RE: if we truncate a table which consists of 100 rows ...

No.Truncate command will delete the table structure.

Is this answer useful? Yes | No

August 30, 2006 01:10:37

Zraeena

RE: if we truncate a table which consists of 100 rows ...

we cant update any no of rows.Bcz truncate is auto commit statemant i.e. it is DDL SQL statemant

Is this answer useful? Yes | No

September 04, 2006 04:19:09

Sanjay Mungekar

RE: if we truncate a table which consists of 100 rows ...

all rows are deleted and hence no rows are updated.

Is this answer useful? Yes | No

October 17, 2006 05:33:35

lokesh rustagi

RE: if we truncate a table which consists of 100 rows ...

no. because though the truncate command the phisical existence is not available. and we can not update the rows of the table. we can not insert the data also.

Is this answer useful? Yes | No

November 07, 2006 14:29:51

pavan reddy

RE: if we truncate a table which consists of 100 rows ...

Truncate a table means delete all rows in table but any rows are not updated.if we want the deleted rows simply type the keyword is rollback

Is this answer useful? Yes | No

November 21, 2006 09:01:24

naina

RE: if we truncate a table which consists of 100 rows ...

Truncate command will delete the entire table it self it will not be able to access again - it delete the entire table structure itself.

Is this answer useful? Yes | No

November 30, 2006 13:23:58 #10

JohnCenzer Member Since: November 2006 Contribution: 2

RE: if we truncate a table which consists of 100 rows ...

Truncate does not delete the table structure. It removes all rows from the table or cluster. Also it cannot be rolled back like a delete can.

Oracle Database also performs the following tasks:

Deallocates all space used by the removed rows except that specified by the MINEXTENTS storage parameter
Sets the NEXT storage parameter to the size of the last extent removed from the segment by the truncation process

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank