what is indexing ? what are different types of indexes
supported by oracle ?
Answers were Sorted based on User's Feedback
Answer / sabeena
Indexing is sorting data, used for fast retrival.
Different types are
b tree index
function based index
reverse key index
bitmap index
compressed index
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / msb.dwh
INDEX R USED FOR FASTRETRIVING OF DATA NOT ONLY FAST BUT
ALSO EFFICTIVE DATA
TYPES OF INDEX R B-TREE AND BIT-MAP
| Is This Answer Correct ? | 4 Yes | 0 No |
How did you plan your Data ware house project?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain about core dimension,
Explain grouped cross tab?
What is normalization, first normal form, second normal form, third normal form?
Explain normalization?
How to answer the question how many fakt table in your datawarehouse and what size it have?
What is critical column?
Explain what are the advantages data mining over traditional approaches?
What is data merging, data cleansing and sampling?
What is incremintal loading?
What are the tools available for etl?