Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6735 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 blob database?
What do you understand by the terms entity, entity type, and entity set in dbms?
How do I create a database in open office?
How many rows can a database hold?
Where is the database stored?
How does index hunting help in improving query performance?
What is the importance of a database?
Write a query to create a duplicate table with and without data present?
What is a file in a database?
What is implicit cursor in dbms?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
What is an artificial (derived) primary key? When should it be used?
What is an extensible database?
List few disadvantages of file processing system.
Explain types of indexing in dbms?
