What is the difference between DELETE and TRUNCATE?
Answer Posted / shilpa
Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between an inner and outer join?
What are the steps for performance tuning.
What is a .db file?
What is asqueryable?
Explain how exception handling is done in advance pl/sql?
what is text? : Sql dba
What are the constraints available in sql?
what does it mean to have quoted_identifier on? : Sql dba
How many tables can a sql database have?
Do prepared statements prevent sql injection?
how to convert character strings to numeric values? : Sql dba
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is mdb stand for?
what is union, minus and interact commands? : Sql dba
What does partition by mean in sql?