Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / taral desai
truncate is faster then delete... truncate don't generate
rollback. truncated data can't be recovered
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
how to restore files with rman?
What is the difference between clustered and non-clustered index? : sql server DBA
what is asm?
what are the differences of where and if in SAS?
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you record information about current session?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what is the diffrence between core dba and apps dba?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what do you understand by fine-grained auditing?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA