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.

Does oracle charge for java?

1043

---

How can I combine multiple rows into a comma-delimited list in oracle?

1039

---

What the is the diff between local index and global index. give some example.

1616

---

Explain index?

1243

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1904

---

Explain a data segment?

1050

---

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

2015

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1364

---

What is a table in oracle?

969

---

What is an oracle user account?

964

---

Explain overloading. Can functions be overloaded?

964

---

Explain what are clusters?

1087

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2302

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2205

---

Give the various rollback segment states.

1032

---