Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / santosh
Basically truncate is a DDL and Delete is DML. You can use
delete to remove rows depending on certain criteria and it
generated redo logs and can be rolled back before you
commit the transaction, Where as the truncate is used to
remove all the data in the table. Once you execute this
command u can not rollback this transaction.and commit is
not required for the truncate statement
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what is the role of dip user in our database?
what is a user-defined lock?
How do you open a cluster administrator? : sql server DBA
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.
which background process invoke at the time of upgradation tell me???
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
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
What is a system database and what is a user database? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what functionality does oracle provide to secure sensitive information?
what is the use of recording information about current session?
Why does Oracle not permit the use of PCTUSED with indexes?
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.