Answer Posted / sandeep desai

B-Tree:-Is made of Branch nodes and Leaf nodes
where
Branch nodes hold the prefix key value and also the link to
Leaf node
whereas,
Leafe node is contains Indexed value and ROWID.

Bitmap:-It consists of the bits for every distinct value

Explain the use of indexes option in imp command.

1258

---

Explain oracle data types with examples?

1077

---

Can select statements be used on views in oracle?

1082

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2173

---

what are steps for interface? where is exchange rate defined in which table?

2234

---

query optmization techniques and quwry analyser+projects+ppts

2464

---

Design database draw er diagram for a certain scenario ?

4626

---

How do I learn what codesets are available in oracle?

1076

---

How to run queries on external tables?

1084

---

How index is implemented in oracle database?

1041

---

How to write a query with an inner join in oracle?

1094

---

Explain implicit cursor.

1074

---

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

1097

---

Can we protect our pl/sql source code?

1080

---

What is the parameter mode that can be passed to a procedure?

1106

---