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

Explain the use of tables option in exp command.

1115

---

Why do we need oracle client?

948

---

How to use regular expression in pattern match conditions in oracle?

1041

---

How to bring a tablespace online?

1079

---

What are the different types of synonyms?

1140

---

What happens if variable names collide with table/column names?

1191

---

Hi Can any one tell me what are the API's used in requisition import.

1923

---

What is the relation of a user account and a schema in oracle?

1080

---

How many anonymous blocks can be defined?

1184

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

---

How to use subqueries in the from clause in oracle?

1111

---

What is the usage of analyze command in oracle?

1093

---

How to use existing values in update statements using oracle?

1066

---

Explain the use of record option in exp command.

1006

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1932

---