Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 14532 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
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how to restore files with rman?
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
what is the diffrence between core dba and apps dba?
how can you schedule a job in database?
What is dcl? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you connect from 10g user to 11g user??
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
