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

how to load the data with one flat file and one rdbms table using joins?

0 Answers   Seventhsense Technologies,


What are the IKM types?

0 Answers   Virtuas,


what is profile in odi?

0 Answers   Hexaware, Seventhsense Technologies,


How many types of km's? And you what are the type's km are used in your project?

0 Answers   Infosys,


What is Session Tasks?

0 Answers   Seventhsense Technologies,






Have you attend the client meetings?

0 Answers   Virtuas,


What are the constraints are used in Ur project?

0 Answers   Tech Mahindra,


What is a scenario in odi?

0 Answers   Accenture,


What are the LKM types?

0 Answers   Virtuas,


What are the types of data contol?

0 Answers   Accenture,


how to write the sub-queries in odi?

0 Answers   Hexaware, Seventhsense Technologies,


What is the use of the Service Knowledge module?

0 Answers   Tech Mahindra,


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)