oracle interview question oracle BITMAP index

Oracle Interview Question - oracle index related questions
1. What is Index? How to create index?
2. What are the types of index?
3. How to find the list of indexes for a given table?
4. Explain B-tree index
5. Explain Bitmap index
6. Explain "Function based" index
7. Explain "Reverse Key" index
8. When to choose what type of index?
9. How to know index is being used?
10. How to monitor index usage?
11. What are the advantages/drawbacks of indexes?

[humayunhimu]

Simply great learning from Siva Academy

[SatyendraKumar-imtu]

Great explanation about the locking mechanism for the tables having BitMap index.

[krishnareddy]

Really excellent tutorials sir...
U r explaing very Interestingly...

[mkr]

Your explanation is awesome .... I became fidaa on pl sql with your outstanding explanation . Doing a great job .

[abhijitmohanty]

Very Informative.. Your examples are very clear and to the point. Please upload some videos related to performance tuning for the oracle interview question segment. Thanks

[swathidasu]

Thanks so much ...Cannot think of better explanation

[ramgour]

great explanation need information for join methods

[abhilashdeshmukh]

Thanks for the explanation, I have one question though regarding the locking of rows.
If we try to fire update on same table from two different sessions without commit/rollback Oracle will not allow anyways, so is it not a universal behavior ?

[MrSakssssss]

Thank you again for this perfectly explained video.

[shashank]

Nice video sir..pls make a video on local and global index when we create partition table on that time We create local Andrew global index...so pls make a video to describe more about same.

[venkatrao]

you have explained very well, Could you please make a video on BITMAP JOIN index.

[siddeshbagali]

Awesome !! we really appreciate your effort..

[AmarjeetSingh-bsyp]

Hi @Siva very nice video
Can you please explain cluster index and non cluster index with examples

[letsplay]

Thank u Sir... Can u plz tell how can we see the explain plan for a particular

[srikanthsuddala]

thank you for the valuable explanation

[etflourmill]

Hi
I like your videos. Very help full

[vivektarab]

0:52 - How Bitmap data is actually stored

1:24 - Create Index Sytax

2:33 - How to know the Bitmap Index is actually works or not

[hemanthraj]

sir will u give any project coaching or real time project explanation??

[deep]

Hi siva,

Please make a video series on partitioning

[mukeshchitte]

Number of comparisons within Index segment are same in Table then, what's the advantage?
@our example finding rows of P's is similar to finding rows of 1's.