Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 7076 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumarsunny9
Truncate is more faster than delete.
in sql you need to write statement: truncate table
table_name
truncate delete all record from table.it remain only
structure of table.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is inner join in database?
What is rdms?
What is a database report?
Write about Transaction Management in Oracle 9i?
What is the difference between a shared lock and exclusive lock?
Can you explain the select into statement?
What is data modelling explain?
What is database or database management systems (dbms)?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What are the features of openedge features?
What is the structure of a database?
Explain the Normalized Relations?
Which database is best for storing large data?
What methods is used to commit the changes made in DataSet object?
What is hot backup (in case of oracle)?
