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
What the different topologies in which replication can be configured? : sql server DBA
how can you find out if a table can be redefined?
How do you trace the traffic hitting a sql server? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is a system database and what is a user database? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What authentication modes does sql server support? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you go about verifying the network name that the local_listener is currently using?
what is grd?
which background process invoke at the time of upgradation tell me???
What the different components in replication and what is their use? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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?