What is the difference between DELETE and TRUNCATE?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / srikanth

15 Answers
25231 Views
Johns Hopkins University, Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between DELETE and TRUNCATE?..

Answer / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Is This Answer Correct ?

2 Yes

1 No

What is the difference between DELETE and TRUNCATE?..

Answer / debi

1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate

Is This Answer Correct ?

2 Yes

2 No

What is the difference between DELETE and TRUNCATE?..

Answer / raam

Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.

ramumcato@yahoo.com

Is This Answer Correct ?

9 Yes

11 No

What is the difference between DELETE and TRUNCATE?..

Answer / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Is This Answer Correct ?

4 Yes

7 No

What is the difference between DELETE and TRUNCATE?..

Answer / amol

Be very careful when deleting records. You cannot undo this
statement! but in mysql...

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More SQL PLSQL Interview Questions

Give an example of Full Outer Join?

1 Answers IBM,

What is input buffer in sql*plus?

0 Answers

what is sql optimization

1 Answers Fidelity,

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers Zensar,

What is data manipulation language?

0 Answers

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers Prodapt,

define data blocks ? : Sql dba

0 Answers

Can we use pl sql in sql server?

0 Answers

Can function return multiple values in sql?

0 Answers

What is scalar function?

0 Answers

Can procedure in a package be overloaded?

1 Answers HCL,

How delete all data from table in sql?