Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6870 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
List few ways to code transactions in an efficient manner?
Explain the terms database and dbms?
What do you mean by fill factor concept with respect to indexes?
Have you heard about sixth normal form?
What is oracle block? Can two oracle blocks have the same address?
What are different types of transaction isolation levels?
Explain the use of assign statement in progress database?
What are the features of openedge features?
Explain the three Level Architecture of the Database System
What are the three levels of data abstraction?
What is limit in dbms?
Is mysql a rdbms?
What are different type of normalization?
Define dbms.
What is string in database?
