Answer Posted / su

we can use USER_INDEXES or DBA_INDEXES
sql> desc user_indexes
index_name
index_type
table_owner
table_name
table_type
and plenty of other columns

sql>SELECT index_name
FROM user_indexes
WHERE table_name = 'EMP';
will give us the index_name, which is how we identify an
index

:) hope this helps

Give the various exception types.

764

---

What is the usage of control file in oracle?

849

---

Explain an index?

904

---

Explain the use of rows option in imp command.

812

---

How to define an anonymous block?

847

---

How data locks are respected in oracle?

839

---

How to create a single index for multiple columns?

787

---

How much memory your 10g xe server is using?

842

---

How can we find out the duplicate values in an oracle table?

845

---

What is sequence?

850

---

How to get execution statistics reports on query statements?

838

---

How many types of segments in Oracle?

820

---

Differentiate between translate and replace?

837

---

What is ordinary table in oracle?

854

---

What is primefaces used for?

820

---