Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25585 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 is dbo in sql?
What is PL/SQL Records?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is the starting oracle error number? What is meant by forward declaration in functions?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What are the different types of a subquery?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How to know the last executed procedure?
What is the trigger in sql?
What are the rules to be applied to nulls whilst doing comparisons?
Explain ttitle and btitle.
What are commit, rollback, and savepoint?
How can we avoid duplicating records in a query?
What is rownum?
What is dialect in sql?
