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

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

0 Answers   TCS,


What is Sequences?

0 Answers   Seventhsense Technologies,


When you used JKM ?

0 Answers   Virtuas,


Can you joined two sources without common column?

0 Answers   Virtuas,


suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

0 Answers   Hexaware, Seventhsense Technologies,






What are the types of Generic profiles types in ODI?

0 Answers   Accenture,


What are the Types of Scd's?

0 Answers   TCS,


Differences between package and loadplans?

0 Answers   Accenture,


what systems can odi extract and load data into?

0 Answers   Hexaware, Seventhsense Technologies,


what is the odi console?

0 Answers   Hexaware, Seventhsense Technologies,


What is StandAlone Agent and default port number?

0 Answers   Accenture,


Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

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)