Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24976 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is example of database?
What is sql and db2?
What types of commands can be executed in sql*plus?
What is string data type in sql?
What has stored procedures in sql?
Can we have two clustered index on a table?
What is the trigger in sql?
How to use sql statements in pl/sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
How to handle bulk data?
What is information schema in sql?
What is output spooling in sql*plus?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
what are the types of subquery? : Sql dba
Is left join inner or outer?
