ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
How many different types of indexes we have in oracle?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How many different types of indexes we have in oracle?
Answer
# 1		 
We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional 
index,Organisational index,cluster index.
 
Is This Answer Correct ?    4 Yes 1 No
Swapna
 
  Re: How many different types of indexes we have in oracle?
Answer
# 2		 
some more additions to the above:
context indexes etc. you can read about it here:
http://www.databasedesign-resource.com/oracle-indexes.html
hope this helps.
 
Is This Answer Correct ?    2 Yes 1 No
Ron
 
 
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
query to find the maximum no persons with same age(age colomn) from emp table  1
What is a View ?  3
What is a deadlock ? Explain .  1
Can we create index on views?  5
What is Rollback Segment ?  1
Define Transaction ?  3
How to define Data Block size ?  1
what is the syntax of UPDATE command?  4
What are the different approaches used by Optimizer in choosing an execution plan ?  1
what is query and types of query Reliance2
What is Private Database Link ?  1
Can anyone give me information about oracle certification  1
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ... Verizon6
What are joins..how many types of joins are there? TCS8
What are the sql clauses supported in the link property sheet ? Oracle1
What are the types of Database Links ?  1
what is RAID technology?which is better RAID 0+1 OR RAID 5?  1
What is Data Block ?  1
a query to select maxmun 3 salaries of employee table Polaris5
What is the maximum number of CHECK constraints that can be defined on a column ?  3
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com