Answer Posted / test

Index simply means sorting of data. Let u stake an example :

EmpID Name
1 A
6 B
5 C
9 D
...
...
2 ZZ

Now if we create index (Talking about btree index) on EmpId
it means creating a segment with the following in sorted
order
EmpId Rowid
1 <some value>
2 ....
5 ...
6 ...
...

Now if we want to search with EmpId, it will do a binary
search and get the rowid in few searches

What operating systems are supported by oracle database 10g xe?

1032

---

What is oracle open database communication (odbc)?

1024

---

Explain compound trigger in oracle?

1031

---

How can you use check constraints for self referential integrity?

965

---

What are oracle functions?

1028

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1776

---

How to loop through a cursor variable?

1082

---

Why does for update in oracle 8 cause an ora-01002 error?

999

---

What are the different types of synonyms?

1134

---

How to create a stored procedure in oracle?

1102

---

How to save query output to a local file?

1023

---

Explain the blob datatype?

1071

---

How to open a cursor variable?

1031

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2305

---

Is there an oracle sql query that aggregates multiple rows into one row?

972

---