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
What is a partition in oracle?
How many anonymous blocks can be defined?
How to update values in a table in oracle?
How to select some columns from a table in oracle?
What is a synonym? What are its various types?
Compare and contrast between sql and sql server and explain its various functions?
What is oracle and what are its different editions?
How can we find out the current date and time in oracle?
How to export several tables together?
What are the logical operations?
How to rename an existing table?
What are the system predefined user roles?
What is a procedure in oracle?
How to rename an index in oracle?
Explain what are the different type of segments?