Answer Posted / pravesh kumar

Truncate
1.Truncate Can be DDL Command.
2.it cannot be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1073

---

which one is currently in used software cmpanies.

2102

---

what is difference between inner join & nested query or subqueries

2962

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2058

---

Can we modify approve purchase order?if yes what is navigation?

1947

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1019

---

What is an Oracle database Full Backup?

1082

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2012

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2206

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1142

---

Explain prerequisites and post activities of oracle database installation

2069

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2152

---

What are different types of transactions in ar? : oracle accounts receivable

1217

---

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

2249

---

default triggers available for reports

2156

---