Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nandini sett
Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is a mutating table and a constraining table?
What are different types of statements supported by sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is materialized view in sql?
how is myisam table stored? : Sql dba
Explain autonomous transaction.
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Explain character-manipulation functions?
Explain the the delete statements in sql?
What are the different types of constraints?
How do I remove duplicates in two columns?
What is view? Can we update view
How is use pl and sql?
What is mutating error in pl sql?
