Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25235 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / anitha
If we are using the delete command means the content of the
table will be deleted.but we can recover that data by using
the roll back query in my sql.
But this one is not possible we can use truncate.so some
times of our carelessness we can loss some valuable and
sensitive datas.
so make sure of that before using truncate...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What pl/sql package consists of?
What is the primary use of normalization?
Which sql statement is used to return only different values?
How do I run pl sql in sql developer?
What is blind sql injection?
What are reports usually used for?
What is cursor explain with example?
Does truncate table reset auto increment?
What are synonyms in sql?
Explain the difference between sql and mysql.
how to enter binary numbers in sql statements? : Sql dba
What is not null in sql?
what are the 'mysql' command line options? : Sql dba
How do temporal tables work?
How do I start pl sql?
