Can we create more than one index on particular column?



Can we create more than one index on particular column?..

Answer / guest

No
But we can create composite index including that particular
column with other columns.

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More Oracle General Interview Questions

What is a database table in oracle?

0 Answers  


How to create a single index for multiple columns?

0 Answers  


How to define an anonymous block?

0 Answers  


Why do you use stored procedures and state some of its disadvantages?

0 Answers  


What do you understand by a database object? Can you list a few of them?

0 Answers  






What is bulk load in oracle?

0 Answers  


Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,


How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  


Explain can a view based on another view?

1 Answers  


How to work with data objects interactively?

0 Answers  


How different is ms access and oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)