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
how can you get actual data change values from previous transactions in oracle?
how can you create a user-defined lock?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What types of replication are supported in sql server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you initialize log miner?
what is the use of recording information about current session?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is replication? : sql server DBA