What is the primary technical function of an 'Index' property within an MS Access database table field designer? MCQ with Answer and Explanation

What is the primary technical function of an 'Index' property within an MS Access database table field designer?
A. It speeds up data searches and retrieval operations on that field while optionally preventing duplicate values.
B. It links child fields to external web hyperlinks automatically.
C. It hides specified columns from being extracted by query layouts.
D. It converts plain text entries into encrypted binary string records.
Answer: Option A
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.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, what is the purpose of the 'Slide Show' tab?
A. To design slides
B. To add animations
C. To set up and run the presentation
D. To insert media

Correct Answer: Option C


Explanation:
The Slide Show tab contains options to start the slideshow, set up the show, rehearse timings, etc. Animations are on the Animations tab, Insert is for media, Design is for design.

This question belongs to: Computer Microsoft Office
Question #2
The shortcut to toggle between insert and overwrite mode in MS Word is:
A. F2
B. Ctrl + I
C. Alt + Insert
D. Insert key

Correct Answer: Option D


Explanation:
Pressing Insert toggles between Insert and Overtype mode.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, which shortcut key is used to insert a new comment?
A. Ctrl + Shift + M
B. Ctrl + M
C. Alt + M
D. Ctrl + Alt + M

Correct Answer: Option D


Explanation:
Ctrl+Alt+M inserts comment.

This question belongs to: Computer Microsoft Office