What is an Index? - How it is implemented in Ora

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

(Continued from previous question...)

199. 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 (Ver 7.0)

(Continued on next question...)

Other Job Interview Questions

• What is an anchoring object and what is its use?
• How can values be passed between precompiler exits & Oracle call interface?
• What is the maximum number of triggers, can apply to a single table?
• What are the two types of views available in the object navigator (specific to report 2.5)?
• What is Privilege Auditing?
• What are visual attributes?
• Any three PL/SQL Exceptions?
• What is a deadlock?
• What is Mirrored on-line Redo Log?
• If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
• More...