Difference between delete & truncate?

Question Posted / brijesh kumar

1 Answers
1315 Views
TCS, I also Faced
E-Mail Answers

Difference between delete & truncate?..

Answer / venki

Delete means when we deleted the row and columns in the table.Then we can give the rollback command again it will regain the data to the table
Truncate means when we deleted the row and columns in the table.it will be deleted permanently rollback command won't work here

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Data Integrator (ODI) Interview Questions

what is oracle data integrator (odi)?

0 Answers Hexaware,

What is the use of the Service Knowledge module?

0 Answers Tech Mahindra,

What are the Types of repositories in ODI?

0 Answers Accenture,

What is the history of ODI?

0 Answers Accenture,

what is profile in odi?

0 Answers Hexaware, Seventhsense Technologies,

what is load plans and types of load plans?

0 Answers Hexaware, Seventhsense Technologies,

what is the odi console?

0 Answers Hexaware, Seventhsense Technologies,

what are knowledge modules?

0 Answers Hexaware, Seventhsense Technologies,

What are types of LOG LEVELS in ODI?

1 Answers Accenture,

How to create sequence in odi?

0 Answers Infosys,

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

0 Answers Hexaware,

What is the use of Markers?

0 Answers Accenture,

For more Oracle Data Integrator (ODI) Interview Questions Click Here