What is difference between TRUNCATE & DELETE?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does cross join work?

502


Why is %isopen always false for an implicit cursor?

568


Why do we create views in sql?

549


What are the different dcl commands in sql?

559


How much does sqlite cost?

553






What is meant by user defined function?

579


Show code of a cursor for loop.

580


What is synonyms?

570


What are sql functions? Describe the different types of sql functions?

551


Is primary key clustered or nonclustered?

556


How do you truncate?

503


What are different clauses used in sql?

583


What is %type in pl sql?

540


Can we change the table name in sql?

527


Can %notfound return null after a fetch?

585