What is meant by an index?

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

(Continued from previous question...)

What is meant by an index?

An index ia set of row identifier (RIDs) or pointers that are logically ordered by the values of a column that has been specified as being an index. Indexes provide faster access to data and can enforce uniqueness on the row in a table.

(Continued on next question...)

Other Job Interview Questions

• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is normalization and what are the five normal forms?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• What RDMS objects are required before you can create a table ?
• When can an insert of a new primary key value threaten referntial integrity?
• What are correlated subqueries?
• What are the column name qualifiers?
• What is a cursor?
• What is a synonym? How is it used
• More...