Answer Posted / guest

Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2364

---

How to create a new oracle data file?

1076

---

What privilege is needed for a user to delete rows from tables in another schema?

1137

---

What is a schema in oracle?

1067

---

What is rich query?

1037

---

How to use "for" statements in oracle?

1123

---

What is open database communication (odbc) in oracle?

1052

---

What are the database administrators utilities available?

1096

---

What are the data types in oracle?

1097

---

how to make an oracle object

2396

---

What is system tablespace?

1153

---

What's dateware house and what's clustor with practicle example

2236

---

When system tablespace is created?

1093

---

What is a snapshot in oracle database?

1073

---

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

1974

---