What is an index? How it is implemented in Oracl

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

234. What is an index? How it is implemented in Oracle database?

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 command

(Continued on next question...)

Other Job Interview Questions

• What is new_form built-in?
• Give the stages of instance startup to a usable state where normal users may access it.
• Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
• What are the two ways by which data can be generated for a parameters list of values?
• How can a square be drawn in the layout editor of the report writer?
• What is a View?
• Which of the two views should objects according to possession?
• How can we reduce the network traffic?
• You see multiple fragments in the SYSTEM tablespace, what should you check first?
• What are PL/SQL Cursor Exceptions?
• More...