Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15575 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
Truncate is to delete the entire data of any table .does not
have criteria deletion
where as Delete can do that job
However Deleted blocks still persists and have to be
shrinked .otherwisem You still feel the Deleted Recs while
you Query Against
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the importance of a recovery model? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is transparent data encryption? : sql server DBA
How to start SQL Server in minimal configuration mode?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different types of indexes available in sql server? : sql server DBA
when does an alert gets signaled?
how can you schedule a job in database?
what is the use of recording information about current session?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the performance views in an oracle rac environment?
