we can utilise the space for record which is uesd to truncate but delete

What is difference between TRUNCATE & DELETE?

Question Posted / rao

Answer Posted / rao

we can utilise the space for record which is uesd to
truncate but delete we cant use same same space.

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between alter trigger and drop trigger statements?

1110

Why should I use postgresql?

1018

explain the difference between delete , truncate and drop commands? : Sql dba

1094

What are the operators in sql?

1030

What is PL/SQL Records?

1191

What is the source code of a program?

1070

How do you run a query?

991

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

Why are cursors used?

1122

How do you delete duplicates in sql query using rowid?

947

How many indexes can be created on a table in sql?

1055

What is attribute indicator in pl sql?

1016

What is the purpose of cursors in pl/sql?

1137

Why do we use joins?

1040

what is the syntax for using sql_variant_property? : Transact sql

1047