Answer / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Answer / debi

1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate

Answer / raam

Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.

ramumcato@yahoo.com

Answer / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Answer / amol

Be very careful when deleting records. You cannot undo this
statement! but in mysql...

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

Is left join faster than join?

0 Answers  

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

What is differance unique key and primary key.

7 Answers   EDS,

What is cold data?

0 Answers  

How to run sql commands in sql*plus?

0 Answers  

What are three advantages to using sql?

0 Answers  

what are the methods using performance tunning in sql and pl/sql

2 Answers  

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

What are the types of join in sql?

0 Answers  

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

Can we change the table name in sql?

0 Answers