UGC NET CSE | December 2015 | Part 2 | Question: 19

Question

A data which improves the performance and accessibility of the database are called:

• A. Indexes
• B. User Data
• C. Application Metadata
• D. Data Dictionary

Answer 1

Answer A

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index in the back of a book.

Refer this

http://www.tutorialspoint.com/sql/sql-indexes.htm