Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15482 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
what do you understand by fine-grained auditing?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is asm?
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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is a user-defined lock?
What is the default port no on which sql server listens? : sql server DBA
what are the differences of where and if in SAS?
What is dbcc? : sql server DBA
how does an oracle clusterware manage crs resources?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is grd?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
