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>;

Differentiate between post-database commit and post-form commit?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

Will you be able to store pictures in the database?

0 Answers  

---

What is query image?

0 Answers  

---

What is backup in Oracle?

0 Answers   MCN Solutions,

---

How to see the table columns used in an index?

0 Answers  

---

What is meant by joins? List out the types of joins.

0 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

Please explain joins in oracle?

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

List out the components of logical database structure of oracle database.

0 Answers  

---

What is meant by recursive hints ?

1 Answers  

---