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

This question is related to Oracle Interview

Questions by srinivasakumar.ch

Showing Answers 1 - 34 of 34 Answers

srinivasakumar

  • Mar 24th, 2006
 

no

  Was this answer useful?  Yes

Ram Kumar

  • Apr 22nd, 2006
 

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

commnad. Therefore, any row will not get updated.

  Was this answer useful?  Yes

Sajid Belvadi

  • Jun 10th, 2006
 

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.

  Was this answer useful?  Yes

VijayaKumar

  • Jul 10th, 2006
 

No.Truncate command will delete the table structure.

  Was this answer useful?  Yes

Zraeena

  • Aug 30th, 2006
 

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

  Was this answer useful?  Yes

Sanjay Mungekar

  • Sep 4th, 2006
 

all rows are deleted and hence no rows are updated.

  Was this answer useful?  Yes

lokesh rustagi

  • Oct 17th, 2006
 

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.

  Was this answer useful?  Yes

pavan reddy

  • Nov 7th, 2006
 

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" 

  Was this answer useful?  Yes

naina

  • Nov 21st, 2006
 

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

  Was this answer useful?  Yes

JohnCenzer

  • Nov 30th, 2006
 

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

 

  Was this answer useful?  Yes

 tURNCATE- remove all the rows ,, that means all tople value

                   delated,   no rollback performed, and no trigger is fired
                 
so 
no any row ii be updated

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions