What is an Index ? How it is implemented in Oracle Database ?
Answer Posted / 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 View All Answers
How do I connect to oracle?
How to load excel data sheet to oracle database
Explain the different normalization forms?
Compare and contrast between sql and sql server and explain its various functions?
what is meant by magic query
How to load data from external tables to regular tables?
How many file formats are supported to export data?
List the parts of a database trigger.
How to use "while" statements in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to define a record variable to store a table row?
What is the data pump export utility?
What is analyze command used for?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
1) Does oracle have any table which contain all the exceptions and it's code internally?