Answer Posted / sandeep desai

Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.

What is system tablespace?

1148

---

How will you differentiate between varchar & varchar2?

1086

---

What are the attributes of cursor?

1104

---

if you ctreate table identity

2428

---

What is a proxy object?

1105

---

What is a sub query? What are its various types?

1273

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

---

What is a parameter file in oracle?

1187

---

What is a nvl function?

1093

---

What is oracle datasource?

1039

---

How to store pictures on to the database?

1031

---

Explain the use of Merge statement in oracle 11g

1074

---

How to convert characters to numbers in oracle?

1112

---

What is ordinary table in oracle?

1238

---

What is the minimum client footprint required to connect c# to an oracle database?

1161

---