what is the difference between delete and truncate?
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 the instance of a relation?
Where is data stored in database?
Explain what is a deadlock and mention how it can be resolved?
Why is foreign key used?
Mention some disadvantages of query?
What is a clause in terms of sql?
Explain the Surrogate Key in DBMS.
Explain what are the types of transparencies?
What is rdbms data?
Describe the difference between embedded and dynamic sql.
What do you know about DBMS?
What are views in dbms?
What is bcnf?
What is unique key in dbms?
I want to export the data date to date from oracle database then what can i do?