Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66536 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kotravel. b
TRUNCATE DELETE
1 cannot be 1 can ba RB
roll back
2 faster than 2 slower than truncate
delete
3 it releses the stroge 3 it does not releses the stroge
sp sp
spaces
| Is This Answer Correct ? | 75 Yes | 8 No |
Post New Answer View All Answers
What is Tax Categories?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
what is semphore explian it?
What is the sql query to find the employee who has Nth maximum salary?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is the use of lockboxes? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
Could you please let me know the interfaces in OM / FA??
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
8. Supporting AP, AR and GL?
Can we modify approve purchase order?if yes what is navigation?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
