In MS Access, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records? MCQ with Answer and Explanation

Question

In MS Access, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?

A. Validation Rule mapping

B. Required set to 'No'

C. Input Mask application

D. Indexed set to 'Yes (No Duplicates)'

Answer: Option D

Solution (By JKSSB Mock Tests)

Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

In MS PowerPoint, which option is used to align objects relative to each other?

A. All of the above

B. Align

C. Distribute

D. Group

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Align options (Align Left, Align Center, etc.) are used to align selected objects. Distribute spaces them evenly, Group combines them.

This question belongs to: Computer Microsoft Office