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

What is flexfileds and use of flexfileds in odi?

0 Answers   Accenture,


What is variable and how many types of variable?

0 Answers   Tech Mahindra,


What is data store? How to create data store?

0 Answers   TCS,


What is the Repository and how many types of repository?

0 Answers   Tech Mahindra,


What is a scenario in odi?

0 Answers   Accenture,


suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

0 Answers   Hexaware, Seventhsense Technologies,


What are the types of data contol?

0 Answers   Accenture,


Is Odi used in oracle products?

0 Answers   TCS,


what is profile in odi?

0 Answers   Hexaware, Seventhsense Technologies,


Which profile required to access solution in Designer tool?

0 Answers   Accenture,


What is the Cdc?

0 Answers   Tech Mahindra,


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

0 Answers   TCS,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)