Compare And Contrast Truncate And Delete For A Table?

1.	Compare And Contrast Truncate And Delete For A Table?
Answer» Both the truncate and DELETE command have the desired outcome of GETTING rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high WATER mark and produces a now rollback. The delete command, on the other HAND, is a DML operation, which will produce a rollback and thus take longer to COMPLETE. Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

Answer»

Both the truncate and DELETE command have the desired outcome of GETTING rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high WATER mark and produces a now rollback. The delete command, on the other HAND, is a DML operation, which will produce a rollback and thus take longer to COMPLETE.

Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

Discussion

No Comment Found

Related InterviewSolutions

Name Two Files Used For Network Connection To A Database.
How Can You Gather Statistics On A Table?
You Have Just Compiled A Pl/sql Package But Got Errors, How Would You View The Errors?
Explain What Partitioning Is And What Its Benefit Is.
How Can You Rebuild An Index?
How Would You Determine Who Has Added A Row To A Table?
What View Would You Use To Determine Free Space In A Tablespace?
What View Would You Use To Look At The Size Of A Data File?
How Do You Resize A Data File?
How Do You Add A Data File To A Tablespace?