diff between DELETE and TRUNCATE?.

Answers were Sorted based on User's Feedback



diff between DELETE and TRUNCATE?...

Answer / sandeep desai

Some more additions

With Truncate command Oracle sets the High Water Mark to
Zero
whereas
With Delete command this doesn't happen since data is not
released from the memory

Is This Answer Correct ?    0 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / chaitanyabilla

delete-low water mark level
truncate-high water level

Is This Answer Correct ?    0 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / sahaja mallarapu

Delete is a DML command.
Truncate is a DDL command.

Using delete we can delete specific rows by applying some
condition.
using truncate all rows are deleted. we cant apply any
condition here.

deleted rows can be rollbacked.
truncated rows cant be rollbacked.

memory occupied by deleted rows cant be reused.
memory occupied by truncated rows can be reused.

Is This Answer Correct ?    0 Yes 0 No

diff between DELETE and TRUNCATE?...

Answer / padma

delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Oracle General Interview Questions

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  


What are inner join and outer join?

3 Answers  


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,


What is oracle used for?

0 Answers  


What is the difference between Delete, Truncate and Drop in Oracle?

0 Answers   MCN Solutions,






What is a Shared SQL pool ?

2 Answers  


what are the advantages of running a database in NO archive log mode?

1 Answers  


How to check the oracle tns settings?

0 Answers  


can you write commit in triggers?

4 Answers  


Explain index?

0 Answers  


How to drop an index in oracle?

0 Answers  


does the query needs a hint to access a materialized view?

1 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 (510)
  • 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)