Answer Posted / vipul.solanki

Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index

there is three type of index

1.unique index
2.cluster index
3.non-cluster index

What are triggers in oracle?

1043

---

Is java required for oracle client?

1003

---

What is a nested table and how is it different from a normal table?

1057

---

What do you mean by merge in oracle and how can we merge two tables?

1052

---

How do we represent comments in oracle?

1057

---

How to create a new oracle data file?

1035

---

What is snapshot is too old? Give and example for better understand.

1607

---

What is oracle instant client?

1029

---

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

1867

---

Why do we use bulk collect in oracle?

1063

---

How would you go about verifying the network name that the local_listener is currently using?

2050

---

How do you bind variables in oracle?

985

---

What are data pump export and import modes?

1073

---

Explain oracle data types with examples?

1035

---

Give the constructs of a package, function or a procedure.

1053

---