Answer Posted / hafiz

Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.

Difference between oracle's plus (+) notation and ansi join notation?

1034

---

What is sharded cluster?

926

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

---

What is an oracle?

958

---

How to create additional tablespaces for an new database?

970

---

Explain a data segment?

1018

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2190

---

Difference between open_form and call_form in oracle.

1094

---

What is primefaces used for?

1009

---

What is a nvl function? How can it be used?

960

---

What is the recommended interval at which to run statspack snapshots, and why?

2861

---

How to retrieve data from an cursor to a record?

1019

---

How to define a variable to match a table column data type?

938

---

Explain do view contain data?

941

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2068

---