Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16001 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
how can you get actual data change values from previous transactions in oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can a session indicate its interest in receiving alerts?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you extract DDL of a table without using a GUI tool?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you initialize log miner?
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
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.
when does an alert gets signaled?
how can you record information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is a system database and what is a user database? : sql server DBA
how can you enable flashback feature?
