Answer Posted / muralidharan

Index is used to fetch the data in a reliable and fast
manner and the types of index avalilable are clustered
index and non clustered index.

Murali
dharanmu@yahoo.com

How to select all columns of all rows from a table in oracle?

1052

---

What are the roles of dba?

1068

---

How a database is related to tablespaces?

1031

---

How to delete an existing row from a table in oracle?

1072

---

What privilege is needed for a user to query tables in another schema?

973

---

What is a cognitive schema?

964

---

How to change program global area (pga) in oracle?

1092

---

Can we save images in a database and if yes, how?

1065

---

What is the maximum number of triggers that can be applied to a single table?

1024

---

How to install oracle odbc drivers?

1093

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4522

---

What are the attributes that are found in a cursor?

1076

---

What happens to the indexes if a table is recovered?

993

---

Difference between the “verify” and “feedback” command?

1362

---