Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15804 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 is the default fill factor value? : 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 are the performance views in an oracle rac environment?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
what do you understand by fine-grained auditing?
what functionality does oracle provide to secure sensitive information?
Where do you find the default index fill factor and how to change it? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you create a user-defined lock?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is ora 24313?what is the procedure to exclude that error?
how can you record information about current session?
What is the importance of a recovery model? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
