This question "In MS Access technique to speed up data retrieval is a) Indexing b) Referencing c) Speeding d) Listing" is asked from Database Management System topic.
The question was asked in Computer Operator Examination conducted by Public Service Commission in 2074. It aims to test candidate's awareness about different database techniques used to make efficient data storage and retrieval.
Show Your Love! Share this page!
In MS Access technique to speed up data retrieval is a) Indexing b) Referencing c) Speeding d) Listing
This question is somewhat straightforward and I believe anybody with little knowledge on database can guess the correct answer.
The provided options Referencing and Listing do not related to speed up data retrieval. Very naive candidate would suspect if Speeding is the correct answer, otherwise you can immediately trace that Indexing is the correct answer for this question.
What is an Index in Database?
A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records. [Source: Wikipedia]
TutorialPoint has a very nice article about Database Indexing. Click here to read that article (opens in new tab)