Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15775 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
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 replication? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what is the use of recording information about current session?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you process messages in order asynchronously?
what do you understand by flashback feature of oracle?
what do you understand by fine-grained auditing?
How can you control the amount of free space in your index pages? : sql server DBA
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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the diffrence between core dba and apps dba?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
