Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is an Index ? How it is implemented in Oracle Database ?

Answers were Sorted based on User's Feedback



What is an Index ? How it is implemented in Oracle Database ?..

Answer / guest

Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.

Is This Answer Correct ?    5 Yes 0 No

What is an Index ? How it is implemented in Oracle Database ?..

Answer / sawant

An index is a database structure used by the server to
have direct access of a row in a table.

An index is automatically created when a unique of primary
key constraint clause is specified in create table comman
(Ver 7.0)

Is This Answer Correct ?    2 Yes 0 No

What is an Index ? How it is implemented in Oracle Database ?..

Answer / ankur jain

An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..

Is This Answer Correct ?    2 Yes 0 No

What is an Index ? How it is implemented in Oracle Database ?..

Answer / nishi

An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle General Interview Questions

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  


What is a system tablespace and when it is created?

0 Answers  


how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,


How does Oracle guarantee data integrity of data changes?

0 Answers  


Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,






What is Private Database Link ?

1 Answers  


Explain the use of record length option in exp command.

0 Answers  


How to restrict the duplicate records in table valuesets

2 Answers   IBM,


How to speed up webrick?

0 Answers  


What is Read-Only Transaction ?

3 Answers  


Explain the function of optimizer in oracle?

0 Answers  


Why do you create or replace procedures rather that drop and recreate.

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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 (509)
  • 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)