Answer Posted / rudrab123

Answer 1 is not he basic function of Index in Oracle or any
databse.
Generally speaking,attaching index to a column in a table,
information of the location of the different values in the
indexed column is also provided.This address is like the
pointer varible in C,and in SQL it is called ROWID(a
pseudocolumn).Let us see he example ....

SQL>select * from students
where id=123;
Students is a databse table and ID is the column in the
table on which we create the index.

On execution of the above query, at first, the ROWID
corresponding to id=123 in students table is found.From
this rowid, the index value for the row of data which is
pointed to by ROWID is found(in very less time).And so the
row is idenified and the entire row data is displayed.
The above serach process is specifically called "TABLE
ACCESS FULL(USING ROWID)).

What is a data lock in oracle?

1015

---

How to resolve name conflicts between variables and columns?

978

---

What is a subquery?

1056

---

How to insert a record into a table?

1018

---

What is a read write transaction in oracle?

1030

---

What are the ways tablespaces can be managed and how do they differ?

2270

---

How to turn on or off recycle bin for the session?

1035

---

How to get execution statistics reports on query statements?

1005

---

Explain implicit cursor.

960

---

How to define a data field as not null?

1059

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1935

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2077

---

Can we connect to ORACLE db using Windows Authentication?

1180

---

What is the string concatenation operator in oracle?

1090

---

What the is the diff between local index and global index. give some example.

1586

---