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 system global area (sga) in oracle?

560

---

How can we delete duplicate rows in a table?

553

---

How to use select statement to count the number of rows in oracle?

540

---

Can we write dml statement in function in oracle?

624

---

What is the difference between hot backup and cold backup in oracle?

513

---

---

How to use windows user to connect to the server?

523

---

what is reindexing?

1161

---

What do you mean by group by clause?

544

---

Briefly explain what is literal? Give an example where it can be used?

528

---

Explain the use of record length option in exp command.

544

---

Oracle

1835

---

What is concurrency in oracle?

530

---

Please explain oracle left join with an example?

572

---

When do you get a .pll extension in oracle? Explain its importance

563

---

How to fetch the row which has the max value for a column?

528

---