Interested to Buy Any Domain ? << Click Here >> for more details...
structural difference between bitmap and btree index ?
- 1 Answers
- 12045 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
How to write text literals in oracle?
Can we protect our pl/sql source code?
Can we create more than one constraint to column ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How to export your own schema?
Explain overloading. Can functions be overloaded?
What is a nested table?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What exactly do quotation marks around the table name do?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is a procedure in oracle?
Oracle General 
