Answer / amit

In Truncate only data are remove from table
where as in delete structure of table are delete.

Answer / rams

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Answer / praveena

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is cardinality?

4 Answers  

---

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

---

How would you determine who has added a row to a table?

0 Answers  

---

Explain an ORA-01555

2 Answers  

---

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

Are These Dff's Flexible?

0 Answers   Oracle,

---