Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / kishore
truncate removes all the rows from a table
it can't be rollback
delete removes all /specific rows from a table
it can be rollback
drop removes whole table
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different sql server versions you have worked on? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is grd?
what are the types of connection load-balancing?
what are the performance views in an oracle rac environment?
Why would you use sql agent? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What is dcl? : sql server DBA
what do you understand by flashback feature of oracle?
What the different components in replication and what is their use? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you enable flashback feature?