Answer Posted / surendra

truncate

it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl

drop

it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl

delete

it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

---

What happens to indexes if you drop a table?

1169

---

Explain view?

1034

---

 How to use an oracle sequence generator in a mapping?

1075

---

What is different types of joins?

1022

---

What to do if the startbd.bat failed to start the xe instance?

1081

---

What are the common oracle dba tasks?

1148

---

What is a nested table?

1058

---

How to retrieve the count of updated rows?

1127

---

How many types of table in Oracle?

1122

---

What is a nvl function?

1032

---

What is oracle analytical function?

1143

---

Can we connect to ORACLE db using Windows Authentication?

1257

---

What is the fastest query method to fetch data from the table?

1361

---

What is data type in oracle?

1125

---