Compare and contrast TRUNCATE and DELETE for a table.

Question Posted / guest

3 Answers
7267 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Compare and contrast TRUNCATE and DELETE for a table...

Answer / mkjmkumar

Delete :
1. It is a DML
2. Speed is Slow
3. We can Use Where Clause.
4. Check Constraints Before delete.

Truncate
1. It is a DDL.
2. Speed is Fast
3. We Cant Use Where Clause
4. Delete All Rows without check of constraints.

Is This Answer Correct ?

7 Yes

0 No

Compare and contrast TRUNCATE and DELETE for a table...

Answer / zikku

Truncate command permanently deletes the information from a
table even after rollback we can't get that information.
Delete command temporarily deletes information from a table
after rollback we can get the information back.

Is This Answer Correct ?

5 Yes

0 No

Compare and contrast TRUNCATE and DELETE for a table...

Answer / ark chowdary

DELETE: IT IS A DML COMMAND(DATA MANIPULATION LANGUAGE) .
IT DELETES DATA MEANS (DELETES ALL RECORDS) IN TABLE.
BUT STRUCTURE WILL BE THERE.
AND
DATA DELETES TEMPERORLY.
THEN USE ROLLBACK WE CAN GET THE DATA.

TRUNCATE: IT IS A DDL COMMAND (DATA DEFNITION LANGUAGE).
TRUNCATE ALL RECORDS IN A TABLE.
BUT STRUCTURE WILL BE THERE.
BUT DATA GOES PERMINANTLY.
WE CANT USE ROLLBACK HERE.
IT SHOLUD NOT WORK. WHY BCZ DATA TRUNCATES
PERMENANTLY.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

What is index? How many types of indexes?

2 Answers HCL,

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers HCL,

What is autocashrule set? : oracle accounts receivable

0 Answers

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers

When the procedures or packagess become invalidate

3 Answers TCS,

How can you enable a trace for a session?

2 Answers

How do you switch from an init.ora file to a spfile?

1 Answers HCL, Wipro,

what is the difference between oracle 81,91,11i

2 Answers i2, Oracle,

deference between & and &&

2 Answers Mphasis,

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers

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

0 Answers IBM,

For more Oracle AllOther Interview Questions Click Here