what is the difference between TRUNCATE and DELETE command in SQL

what is the difference between TRUNCATE and DELETE command
in SQL

Question Posted / william_vijay

23 Answers
66558 Views
ICICI, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between TRUNCATE and DELETE command in SQL..

Answer / amit

In Truncate only data are remove from table
where as in delete structure of table are delete.

Is This Answer Correct ?

3 Yes

9 No

what is the difference between TRUNCATE and DELETE command in SQL..

Answer / rams

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Is This Answer Correct ?

13 Yes

21 No

what is the difference between TRUNCATE and DELETE command in SQL..

Answer / praveena

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

Is This Answer Correct ?

13 Yes

43 No

Post New Answer

More Oracle AllOther Interview Questions

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

0 Answers

What is auto invoicing? Explain : oracle accounts receivable

0 Answers

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers Cap Gemini,

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers IBM, Oracle,

why r u using etl tool.

2 Answers

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers

what are the tools used for oracle 10g in real time.

0 Answers IBM,

How do you resize a data file?

2 Answers

can u give guidance abt packages of plsql

0 Answers Mphasis,

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers Ion Exchange,

what is debit memo and credit memo in AR?

1 Answers

For more Oracle AllOther Interview Questions Click Here