INTERVIEW QUESTIONS DATABASE SQL DETAILS

Question: TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ?

Answer: Both will result in deleting all the rows in the table EMP..

Both will result in deleting all the rows in the table EMP.. Source: CoolInterview.com

A delete statement deletes all records in the table, but it does not free any space. A Truncate statement frees the space as well. However, a truncate can not be rolled back but delete can be rolled back. Source: CoolInterview.com

We can't use WHERE clause with TRUNCATE.
TRUNCATE is faster compared to DELETE. Source: CoolInterview.com

Here truncate is DDL commond and delete is DML commond,More over Truncate deletes all records including spaces also but its not in delete,means only records will be deleting with delete commond. Source: CoolInterview.com

Delete :- It is use to delete the rows from the table.

Truncate:- It will delete the whole table. Source: CoolInterview.com

TRUNCATE is more fastre than DELETE. Source: CoolInterview.com

using delete o/p is no.of rows are deleted

using turncate o/p table is deleted Source: CoolInterview.com

Delete may used with where clause set condition to delete specified rows in a table. but it not possible with truncate Source: CoolInterview.com

truncate is DDL statement and hence after executing this database goes into consistent sate and you no need to fire COMMIT.but,delete is DML statement and hence after executing this database does not go into consistent sate and you need to fire COMMIT to make it consistent.otherwise set AUTOCOMMIT ON Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question