Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15585 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / d.elumalai
DELETE:
1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.
TRUNCATE:
1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is difference between sql function and stored procedure?
Explian rowid, rownum? What are the psoducolumns we have?
How is data stored on a disk?
What programs use sql?
What is difference between my sql and sql?
Show code of a cursor for loop.
What is the basic structure of an sql?
What is difference between function and trigger?
Can a commit statement be executed as part of a trigger?
How to add a column ‘salary’ to a table employee_details?
Can you rollback after commit?
What are types of exception?
What is recursive join in sql?
what are tables and fields? : Sql dba
what tools available for managing mysql server? : Sql dba
