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 the use of analyse option in exp command.
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
How to update values in a table in oracle?
How a database is related to tablespaces?
What is different bet native dynamic sql and Dbms_Sql?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to put more than 1000 values into an oracle in clause?
Describe Referential Integrity ?
Explain the use of inctype option in exp command.
What do you mean by merge in oracle and how can you merge two tables?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Without giving condition how to retrieve the unmatched records from table.