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

What are the types of trigger in oracle?

913

---

what is the difference between data migration and production migration.

2274

---

How to Truncate Table in Oracle

1090

---

What is a static data dictionary in oracle?

1023

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2019

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2197

---

What is materialized view in Oracle?

1042

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2209

---

How to recover a dropped table in oracle?

983

---

What is the meaning of recursive hints in oracle?

992

---

Why do we need oracle client?

885

---

What happens if you use a wrong connect identifier?

978

---

How to delete a column in an existing table?

1018

---

How can windows applications connect to oracle servers?

983

---

Explain integrity constraints?

1056

---