Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajesh
Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.
Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what is sql?
what are wild cards used in database for pattern matching ? : Sql dba
What is equi join in sql?
Why having clause is used in sql?
Explain dml and ddl?
How do I order by ascending in sql?
Explain the commit statement.
How many types of cursors are available in pl/sql?
Does inner join remove duplicates?
Can we join more than 2 tables in sql?
What is normalization in sql?
when MSQL8.0 is in market
What is an implicit commit?
What is nvarchar in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
