Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


diff between DELETE and TRUNCATE?.

Answers were Sorted based on User's Feedback



diff between DELETE and TRUNCATE?...

Answer / manoj.oracle

Delete command is a dml command
truncate command is a ddl command

Delete command has a where clause.
truncate hasn't where clause.

Delete doesn't release memory space(means we can rollback
the deleted rows)
truncate releases memory space(means we can't rollback)

By using synonym we can delete a rows(Delete command).
By using synonym we can't delete a rows(Truncate command).



Is This Answer Correct ?    29 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / pr@$@d

1 TRUNCATE is a DDL command whereas DELETE is a DML command.
2 TRUNCATE is much faster than DELETE.
Reason:
a) When you type DELETE. All the data get copied into
the Rollback Table space first. Then delete operation get
performed. That’s why when you type ROLLBACK after deleting
a table, you can get back the data (The system gets it for
you from the Rollback Table space).All this process takes
time. But when you type TRUNCATE, it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster. Once you truncate you can’t get back
the data.
b) TRUNCATE command resets the High Water Mark for the
table but DELETE does not. So after TRUNCATE the
operations on table are much faster.
3 You can’t rollback in TRUNCATE but in DELETE you can
rollback. TRUNCATE removes the record permanently.
4 In case of TRUNCATE, Trigger doesn't get fired.But in DML
commands like DELETE .Trigger get fired.
5 You can’t use conditions (WHERE clause) in TRUNCATE.But
in DELETE you can write conditions using WHERE clause

Regards,
-Pr@$@d Reddi.
prasadreddi_mca@yahoo.com

Is This Answer Correct ?    6 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / thirupathi.l

delete is a dml command using this we can getback the records.
it will not call inmplicit commit.
perfomance slow in case of delete no.of records.
truncate is a ddl commnd.itwillcall implicit commit
we can't get back the record
performance good in case of deleting no.of records

Is This Answer Correct ?    4 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / shree

Delete command always used with where clause.
but Truncate is not.

Delete command deletes only selected rows/records from table
which are defined in where clause.
But Truncate command deletes all records from the Table
without using where clause.

Is This Answer Correct ?    4 Yes 1 No

diff between DELETE and TRUNCATE?...

Answer / ron

To add to ans#1. truncate needs drop table level priviledges.

Is This Answer Correct ?    3 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / shilpa.oracle

Answer given by Manoj is Absolutely correct.

Is This Answer Correct ?    2 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / dhananjay mukhedkar

The Answer given by Prasad Reddi is perfect.

Is This Answer Correct ?    2 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / kumar

DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it
slow.
TRUNCATE TABLE also deletes all the rows in a table, but it
won't log the deletion of each row, instead it logs the
deallocation of the data pages of the table, which makes it
faster.

The records deleted through DELETE can be roll backed.
The records deleted through TRUNCATE can't be roll back.

If we are using TRUNCATE ina Transaction then only we can
do the roll back else not.

Both will delete the data but not the stucture of the table.

Is This Answer Correct ?    1 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / p.baskar

DELETE is DML Command, TRUNCATE is DLL Command.

DElete used to particular record or, all records from table.
But TRUNCATE only relete the all records.

Ee can rollback the DELETE Command, But we cant rollback the
TRUNCATE

Is This Answer Correct ?    1 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / ron

again to add to my earlier positing, many forget that is the
table has materialized view log truncating table will
corrupt the materialized view.

in that case you have to user:
truncate table schema_name.table_name purge materialized views;

you can read more about it here:
http://www.psoug.org/reference/truncate.html

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle General Interview Questions

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers   iFlex,


How to use subqueries with the in operator using oracle?

0 Answers  


Difference between open_form and call_form in oracle.

0 Answers  


How to use fetch statement in a loop?

0 Answers  






What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,


How to invoke the data pump import utility?

0 Answers  


What is format trigger?

0 Answers  


How to find 1st, 2nd, 3rd highest using select select statement not using rownum

2 Answers  


How to use in conditions in oracle?

0 Answers  


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


Use of an integrity constraint is better to validate data. Explain

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)