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 |
Explain oracle data types with examples?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What is oracle rownum?
What is Database Buffers ?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is a subquery?
Does oracle database need java?
Can we protect our pl/sql source code?
What do database buffers contain?
How can we view last record added to a table?
26. Display the earliest shipping date in the format: DD/MON/YYYY