structural difference between bitmap and btree index ?
Answer / 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
| Is This Answer Correct ? | 10 Yes | 3 No |
create one table to capture an employee details with a primary key.
How to use "if" statements on multiple conditions?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
How to retrieve values from data fields in record variables?
what are steps for interface? where is exchange rate defined in which table?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to rename an existing table?
Can objects of the same Schema reside in different tablespaces.?
What do you know about normalization? Explain in detail?
Explain the concept of the DUAL table.
 What are the oracle DML commands possible through an update strategy?
How to start a specific oracle instance?