Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15484 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 generate profile of pl/sql applications to identify performance bottlenecks?
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 is dcl? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what are the benefits of flashback feature?
What types of replication are supported in sql server? : sql server DBA
What authentication modes does sql server support? : sql server DBA
what is the role of dip user in our database?
What is fill factor? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you initialize log miner?
What would you do with an "in-doubt" distributed transaction?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what are the types of connection load-balancing?
