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 is a nvl function?

956

---

Why is oracle so popular?

941

---

How to start an oracle instance?

950

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2051

---

what is the dual table in oracle?

932

---

What do you mean by a deadlock?

1008

---

What are the different windows events activated at runtime ?

2832

---

How to create a new tablespace in oracle?

932

---

What are the uses of synonyms?

1082

---

What are the oracle differences between nvl and coalesce

1065

---

if you ctreate table identity

2313

---

What are the various oracle database objects?

1090

---

How to start your 10g xe server from command line?

998

---

Does oracle partitioning improve performance?

942

---

What is blob datatype?

1052

---