Difference between delete & truncate?

Question Posted / brijesh kumar

1 Answers
1683 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

how to remove the duplicate in odi?

0 Answers Hexaware, Seventhsense Technologies,

What are the LKM types?

0 Answers Virtuas,

What are types of LOG LEVELS in ODI?

1 Answers Accenture,

How to move objects from DEV to QA and QA to PROD Environments?

0 Answers Accenture,

What are the types of data contol?

0 Answers Accenture,

What is J2EE Agent and port number?

0 Answers Accenture,

what is oracle data integrator (odi)?

0 Answers Hexaware,

In topology manager where the data are stored?

0 Answers Tech Mahindra,

what systems can odi extract and load data into?

0 Answers Hexaware, Seventhsense Technologies,

Where is the multi connections are used in ORACLE DATA INTEGATOR?

0 Answers TCS,

Does my odi infrastructure require an oracle database?

0 Answers Hexaware,

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,

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