Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 create sequence in odi?

0 Answers   Infosys,


Difference between case & decode?

0 Answers   TCS,


can we implement package in package?

0 Answers   Hexaware, Seventhsense Technologies,


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

0 Answers   Hexaware, Seventhsense Technologies,


Have you attended the client meetings?

0 Answers   Virtuas,


What are the types of Generic profiles types in ODI?

0 Answers   Accenture,


How you find which is the latest record in SCD type2 transformation?

0 Answers   Virtuas,


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,


How to send the emails for odi?

0 Answers   Infosys,


In topology manager where the data are stored?

0 Answers   Tech Mahindra,


Have you created fact table and dimension tables?

0 Answers   Virtuas,


What is the variable?

0 Answers   Infosys,


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