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 are the differences between char and varchar2 in oracle?
What are joins, explain all types of joins?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is the simplest tool to run commands on oracle servers?
What is a read only transaction in oracle?
What are the various types of snapshots ?
What are triggers in oracle?
How to update a table row with a record?
How to convert characters to times in oracle?
What is the meaning of recursive hints in oracle?
What is merge in oracle?
Use of an integrity constraint is better to validate data. Explain
How can I create database in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?