Oracle Interview Question oracle index related questions

Description:
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 indes?
List of all the SQL and PLSQL interview questions @ sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html

[@bhushanpalse516]

No one on KZbin, teaching like you sir, excellent

[@SivaAcademy]

My pleasure bro, thank you

[@sandipkarhale658]

mind blowing explanation sir..the way of your teaching is awsm.. you did great job..keep it up..

[@SivaAcademy]

Thanks a ton

[@MSVH-zp6kd]

All the videos are great 👍🏻👍🏻👍🏻

[@SivaAcademy]

🙏🙏💐

[@nishantchavan2980]

Thanks for this video. U have great skills . Pl keep contributing

[@Deepseemaa]

awesome explanation.This is what i was searching for. Thanks a lot

[@SivaAcademy]

My pleasure, welcome 🙏💐

[@TheAbc9989]

Nice explation sir !! Kindly help with oracle architecture vedio and related interview questions please.

[@jay.shah96]

You have done a great job!!! Kudos!

[@SivaAcademy]

Thank you so much :-)

[@ibbure]

Superb explanation bro hatss of to you... awesome yaaarrrr

[@SivaAcademy]

Thanks for your comments bro 🙏

[@balajilb1348]

Mind blowing explanation sir... Thank you so much!!!!!

[@SivaAcademy]

My pleasure bro, thank you

[@latesttelugumovies5532]

Only one word ur the my life torch bearer 🔦 Tnq is a small word

[@SivaAcademy]

🙏🙏🙏

[@sanjanareddy4289]

Really great job and thanks alot for doing this.

[@SivaAcademy]

My pleasure, thank you

[@shahbazhussain1492]

Sir..... the way u r teaching is fantastic.....

[@SivaAcademy]

@Shahbaz, thanks for your comment bro 🙏🙏

[@vijaylamba6179]

Excellent lecture

[@ravivarma5094]

Hello Siva, the knowledge you are sharing is extraordinary😊

[@SivaAcademy]

Thank you so much

[@Ganeshay-996]

What is "index clustering factor" ? select one or more relevant answer it shows the rate of index fragmentation , it's a metric relevant to the keys spread in index, it relates to the data organization in table, it is the number of keys used in indexed table cluster

[@devilsgaming5915]

Sir your videos making my life much more easier

[@SivaAcademy]

Its my pleasure, thank you

[@tamilarasu5432]

Can you explain about cluster index and non cluster index and Partitioned with all types. These questions maximum asking in interviews

[@bhaveshpatil6402]

Hello Great Explain.. Just one question. How betree works internaly in case of index created on multiple columns?

[@ranajparida3902]

Hello Siva, Below are related to Index. Please let me know the answers 1. Online index rebuild and locking 2. Differences between online and standard index rebuild 3. What does it mean in Index 3.1 rebuild online parallel 63 nologging 3.2. noparallel,logging Regards, Ranaj Parida.

[@Pras2winma]

Only siva garu can explain clearly ......

[@SivaAcademy]

😁My pleasure

[@vijayak7473]

Good explanation 👍.But in my query having indexes in where clause of cloumns all and I am not using any function based indexes but it will choose full table scan ? Can u explain why ?

[@someswarak7210]

Q) In Employee table we have column in that we are going insert the gender data like male, female, other. Which index we can use? And how to decide this index right for this column ?

[@ksthiyanes]

Can we create different type of index on the column have indexes already . Ex: eno have btree and i try to create bitmap with eno,ename is it possible.. in this case Oracle which index will pickup primary as btree or bitmap

[@jananijanani6674]

Thank you so much sir..Clearly understood..

[@SivaAcademy]

Thank you

[@arunk8386]

Super.. 1st class

[@SivaAcademy]

🙏👍Welcome

[@venkatamaddina196]

Very clear and perfect explanation. So mean while request you to share the videos related to performance tuning in real time with explain plan interpretation. And also the DB architecture

[@SivaAcademy]

@Venkat. Thanks for your comment, sure will post performance tuning videos soon, please stay tuned.

[@sumathijeyakumari2752]

what is clustered and non clusterd index how it is related to this btree bitmap

[@vipul1177]

Very well explained....

[@SivaAcademy]

Thanks Vipul for your comment :-)

[@srushtibhowate3632]

Sir will u plz tell how to create a item in runtime

[@vijaydubey1734]

Great explanation

[@SivaAcademy]

Welcome 💐🙏

[@sagarjadhav299]

good explained please make video on performance tuning

[@SivaAcademy]

Thanks Sagar, I am working on performance related videos, will be posting soon.... stay tuned.

[@bharathipandian45]

Siva, I need unux and sql production support questions

[@hanishsyan1322]

Hi Sir, Can you please make a video on clustered and non clustered indexes and explain the difference.

[@SivaAcademy]

Sure please stay tuned 👍

[@dhanashreehadawale6503]

greattt

[@SivaAcademy]

Thank you

[@swarupbiswal4499]

Sir plz make a video in can we create a index on view? If yes then which type of view we can create?

[@anupgaikwad1157]

How many columns of a table can indexed??

[@sangamithiranmass3544]

Please give link while refer another videos which posted by you. I have really confused and tired while searching index related videos.....it would be very help for new comers 😊

[@SivaAcademy]

Sure, will update in description soon, please stay tuned

[@option_guy666]

Superb explanation sir. Can you please make video on local index ,global index. And the concept of partition pruning. Thanks for all videos 🙏

[@SivaAcademy]

As soon as possible

[@ManojKumar-il8vt]

Sir pls share index relataed answers on next vedio bcs in this u just tell abt index, hope u will share other questions answers on next vedio

[@SivaAcademy]

ya Manoj, Its diff to cover all the questions in single video, thats the reason, I am splitting to multiple videos, all the questions will be covered in upcoming videos

[@suryatanyarout3551]

Sir can you make a video of oracle architecture interview questions.. I was asked about in memory processing. Then how data is stored and retrieved

[@SivaAcademy]

Sure, please stay tuned

[@shaikrasheed2861]

Sir please explain performance tuning concepts??

[@SivaAcademy]

@Shaik,Sure, will be starting performance related video series soon, Please stay tuned. Thanks,Siva

[@m.s.k5300]

When it will start Siva garu

[@ranajparida5412]

Prepaire practical questions on Oracle analytical function.

[@SivaAcademy]

Sure, please stay tuned for videos on analytical functions

[@sonalisuman7921]

When asked what are the different type of indexes, when should be the answer unique, clustered and non- clustered indexes?

[@SivaAcademy]

in general, you can say about bree, bitmap, function and reverse key index, if interview specifically ask for clustered, local and global index, then you can explain the same

[@ankursrivastava5148]

Please create video for explain plan

[@SivaAcademy]

Sure please stay tuned

[@enjoyfriends873]

Explain index skip scan ?

[@chaithanyamannem5040]

Please explain about partitions

[@SivaAcademy]

Sure please stay tuned

[@pradeepverma8277]

Nice video sir, Is there any xml related demo is avaiable ?

[@SivaAcademy]

Not yet, will post it soon, please stay tuned

[@jerlinvarkey1832]

Can u explain analytical functions, and use of connect by , level statements

[@SivaAcademy]

@Jerlin, Sure, i will post videos on analytical functions and hierarchical queries, please stay tuned.

[@mugilans18]

Excellent

[@SivaAcademy]

🙏, Thanks bro......