Difference between delete & truncate?



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

Difference between 10g & 11g in odi?

0 Answers   TCS,


What is J2EE Agent and port number?

0 Answers   Accenture,


What are the types of Generic profiles types in ODI?

0 Answers   Accenture,


Tell me some differences between ODI 10g and ODI 11g?

0 Answers   Accenture,


Which profile required to access Models in Designer tool?

0 Answers   Accenture,






If you are working Microsoft excel, which type of file you used .excel or .csv?

0 Answers   Virtuas,


What is flexfileds and use of flexfileds in odi?

0 Answers   Accenture,


How to create sequence in odi?

0 Answers   Infosys,


how to handle exceptions?

0 Answers   Hexaware, Seventhsense Technologies,


What is Memos?

0 Answers   Seventhsense Technologies,


What is File steps?

0 Answers   Infosys,


Difference between case & decode?

0 Answers   TCS,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)