What is difference between TRUNCATE & DELETE?
Answer Posted / amedela chandra sekhar
Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain autonomous transaction.
How can we optimize a sql query?
What is graph sql?
How to place comments in pl/sql?
What is vector point function?
What is thread join () in threading?
How do you clear the screen in sql?
What is a primary key called that is made up of more than one field?
What does (*) mean in sql?
Is sql scripting language?
Can a key be both primary and foreign?
what are date and time data types? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is a column in a table?
I need a function for a train ticket reservation please answer it thanks in advance