What is the diff between Truncate table / delete <table
name> purge

Answers were Sorted based on User's Feedback



What is the diff between Truncate table / delete <table name> purge..

Answer / murthy

TRUNCATE:-IT WILL DELETE ALL THE EXISTING RECORDS IN A TABLE

SYNTAX:-TRUNCATE TABLE <TABLE NAME>

DELETE:-IT WILL DELETE THE RECORDS IN A TABLE DEPENDINFG ON
THE GIVEN CONDITION.

SYNTAX:-DELETE FROM <TABLE NAME> WHERE <CONDITON>


PURGE:-AFTER PERFOMING DROP OPERATION THE TABLES WILL STORE
AT UNDO LOGS SO TO DELETE THE DATA COMPLETELY FROM TAHE
DATA BASE WE WILL PURGE THE RECYCLEBIN.

SYNTAX:-PURGE RECYCLEBIN.

Is This Answer Correct ?    10 Yes 4 No

What is the diff between Truncate table / delete <table name> purge..

Answer / d.elumalai

DELETE:

1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.

TRUNCATE:

1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.

Is This Answer Correct ?    6 Yes 0 No

What is the diff between Truncate table / delete <table name> purge..

Answer / papia

Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is normalization in a database?

0 Answers  


What is the maximum database size for sql express?

0 Answers  


What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  


why use cursors?

5 Answers   Oracle,


How much does sql certification cost?

0 Answers  






What does “select count(1) from tab” result?

9 Answers   IBM,


How many types of cursors are available in pl/sql?

0 Answers  


Can I learn sql in a week?

0 Answers  


what are the advantages of using stored procedures? : Sql dba

0 Answers  


what is isam? : Sql dba

0 Answers  


What does partition by mean in sql?

0 Answers  


what is data control language? : Sql dba

0 Answers  


Categories