Answer Posted / sudev kuma rmishra

two types
A.implicit B.explicit

A.implicit index

automatically created when we mention primary key or unique key

B.explicit index

these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index

How to get a list of all user accounts in the database?

1088

---

Explain the use of compress option in exp command.

1021

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2185

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1848

---

How to join two tables in a single query using oracle?

997

---

Explain the use of rows option in exp command.

1092

---

How to define an anonymous procedure without variables?

1107

---

What is the sid in oracle?

967

---

What happens if you lost a data file?

1036

---

What is a snapshot log?

1003

---

What is the meaning of recursive hints in oracle?

1046

---

What is an oracle wallet?

942

---

How do I find the database name in oracle?

1039

---

How to call a stored function with parameters?

1046

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2971

---