What is the primary technical function of an 'Index' property within an MS Access database table field designer?
A. It hides specified columns from being extracted by query layouts.
B. It links child fields to external web hyperlinks automatically.
C. It speeds up data searches and retrieval operations on that field while optionally preventing duplicate values.
D. It converts plain text entries into encrypted binary string records.
Answer: Option C
Solution (By JKSSB Mock Tests)
Indexes optimize search efficiency and data sorting steps in a database field, though they can increase processing time slightly during record insertion updates.
No comments yet. Be the first to start the discussion!