Answer / 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

Answer / taral desai

truncate is faster then delete... truncate don't generate
rollback. truncated data can't be recovered

Answer / 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.

Answer / sridhar

truncate and delete are deltes all rows in the table but truncate is much faster than delete.
and if u delete row in the delte deletion of each gets logged in the transaction log.
truncate there is no way to log in transaction log

Answer / ramesh

Truncate is to delete the entire data of any table .does not
have criteria deletion
where as Delete can do that job
However Deleted blocks still persists and have to be
shrinked .otherwisem You still feel the Deleted Recs while
you Query Against

Answer / kishore

truncate removes all the rows from a table
it can't be rollback
delete removes all /specific rows from a table
it can be rollback
drop removes whole table

Answer / monal

IN MSSQLSERVER TRUNCATE RESETS IDENTITY VALUE OF COLUMN
WHILE DELETE DOESN'T RESETS IDENTITY VALUE OF COLUMN

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

What are the commands you'd issue to show the explain plan for "select * from dual"?

1 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

How would you best determine why your MVIEW couldn't FAST REFRESH?

1 Answers  

What is the difference between dropping a database and taking a database offline? : sql server DBA

1 Answers  

what is difference between user managed backup and rman backup?

1 Answers   CTS,

If we issue alter database begin backup. What happens to database?

2 Answers  

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

How would you force a log switch?

4 Answers  

How do you add a data file to a tablespace?

3 Answers  

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

0 Answers   Oracle,