Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65399 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan_1981
truncate is ddl command.its faster than delete as it doesnt
have go through the rollbacks etc.truncate being a ddl is
auto commit.we can only truncate the whole table(cant use
where clause).once table is truncated we cant rollback the
changes.when a table is truncated the memory occupied is
released.that id the water mark is adjusted.
delete is a dml command and can be rolled back.is slower
than truncate as it is dml has to go through rollback
segments etc.we can use where clause with delete.when a
table is deleted memory occupied is not released ans also
the water mark is not adjusted.
| Is This Answer Correct ? | 153 Yes | 11 No |
Post New Answer View All Answers
What is the difference between recovery and restoring of the oracle database?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
key flexfield structure
can we use lexical perameter in oracle plsql if yes how
please send me oracle pl/sql exp resume. and also faqs...
Give two methods you could use to determine what DDL changes have been made.
How would you go about increasing the buffer cache hit ratio?
What is mrc and what is its use? : oracle accounts receivable
Explain the use of table functions.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is the importance of batch source set up in ar? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
how to replace not in with not exist?
