Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16033 Views
- I also Faced
- E-Mail Answers
Answer Posted / amsu
Truncate is a DDL and delete is a DML command. Once you
truncate a table you cannot rollback where as you can
rollback from the delete command. When you truncate a
table it release the space and it resets the highwater
mark. Delete won't release the space and it won't resets
the highwater mark.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is a crs resource?
what do you understand by fine-grained auditing?
how can you connect from 10g user to 11g user??
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the commands used in dcl? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the recovery models for a database? : sql server DBA
how does an oracle clusterware manage crs resources?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Can you redefine a table online?
