Answer Posted / gayathri

if you compare the salary slip u can find

How many categories of data types?

997

---

Why do you create or replace procedures rather that drop and recreate.

1011

---

How to create lov dynamically at runtime & attach to text field?

1204

---

Explain oracle 12c new features for developers?

1061

---

how to clone 9i Database on to 10g Database.

2340

---

What is oracle data type?

968

---

What is execute immediate in oracle?

1023

---

Which environment variables are absolutely critical in order to run the OUI?

2120

---

What do you understand by a database object? Can you list a few of them?

1018

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5562

---

What is oracle datasource?

993

---

State and explain about oracle instance?

1000

---

What is index in Oracle?

1075

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2136

---

How will you write a query to get a 5th rank student from a table student_report?

1866

---