Compare and contrast TRUNCATE and DELETE for a table.
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
when does an alert gets signaled?
What are statistics, under what circumstances they go out of date, how do you update them?
what are the performance views in an oracle rac environment?
What is the default port no on which sql server listens? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the use of ocr?
Why would you use sql agent? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what is the role of dip user in our database?
What is the difference between clustered and non-clustered index? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different sql server versions you have worked on? : sql server DBA