Answer / sowjanya

Drop Statement deletes the Table structure from the database.
Truncate statement will delete the entire data from Table
and keeps the Table structure as it is in the DB.

Answer / samad

ya its correct sowjanya

DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible

DELETE - deletes all records from a table, the space for the
records remain rollback is possible

Answer / chandana

Drop :
1.Deletes the entire table records as well as the table
structure.
2.It is a DDL Command.
3. Logs are not maintained.
4. Auto Commited.
5.Where clause cannot be used in the Drop statement.Synatx:
Drop table <Table_Name>

Trunctae:
1. Deletes the entire table records ,retains the table
structure.
2. Its a DDL Command.
3. Logs are not maintained. So faster in performace than
Delete.
4. Auto Commited.
Cannot be Rolled Back.
5.Where clause cannot be used with truncate statement.
Truncate Table <Table_Name>;

Delete:

1. Deletes the table records based on condtions ,retains
the table structure.
2. Its a DML Command.
3. Logs are maintained.So slower than trucate.
4. No Auto Commited.So can be Rolled Back.
5.Where clause can be used with truncate statement.
Syantx:
Delete from <Table_Name> where <Condition>;

what is the difference between primary key & foreign key?

57 Answers   CTS, Infosys, La Multi, Sparsh, Wipro,

---

What are Schema Objects ?

2 Answers  

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

What are the different types of trigger and explain its various uses and functions?

0 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

what is the scenario where you take the database to NoArchivelog mode?

0 Answers  

---

How to use attributes of the implicit cursor in oracle?

0 Answers  

---

How to write numeric literals in oracle?

0 Answers  

---