In MS Access, what is a 'Primary Key'? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what is a 'Primary Key'?

A. A field that uniquely identifies each record in a table

B. A field that stores external data

C. A field used for sorting

D. A field that allows duplicate values

Answer: Option A

Solution (By JKSSB Mock Tests)

A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

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

In Access, what is the purpose of the 'Validation Rule' property?

A. To format the field display

B. To set a default value

C. To restrict the values that can be entered in a field

D. To define a relationship

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Validation Rule limits the data that can be entered, e.g., >0. Default Value sets initial value, Format controls display, Relationship links tables.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function calculates the total of a range but ignores error values?

A. AGGREGATE

B. SUMPRODUCT

C. SUM

D. SUMIF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.

This question belongs to: Computer Microsoft Office

Question #3

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

A. Input Mask application

B. Validation Rule mapping

C. Required set to 'No'

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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
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

Explore All Microsoft Office MCQs