Answer Posted / daid kuamr

Implicite index is created by oracle Internally
ex: when we make a primary key in a Column then implicit
Index created which is Clustered Type index(Default)
while Explicite index created by "Create Index Command'
User

What is a system tablespace and when it is created?

970

---

Explain the use of file option in exp command.

1129

---

What are the predefined tablespaces in a database?

1081

---

How many types of synonyms in Oracle?

1122

---

State all possible different index configurations a table can possibly have?

996

---

How many types of table in Oracle?

1119

---

What is backup in Oracle?

1004

---

What is Trigger in Oracle?

1170

---

How to define an oracle sub procedure?

1144

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1725

---

What is max rowid in oracle?

1025

---

what is the difference between restoring and recovering?

1011

---

How to create id with auto_increment on oracle?

990

---

how to handle exceptions in post production

1424

---

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

4520

---