In Access, which of the following is a valid way to set a primary key? MCQ with Answer and Explanation

In Access, which of the following is a valid way to set a primary key?
A. Use the Primary Key button in Design View
B. Both A and B
C. Set in Datasheet View
D. Right-click the field in Design View and select Primary Key
Answer: Option B
Solution (By JKSSB Mock Tests)
You can set primary key by right-clicking or clicking the Primary Key button in Design View.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which function in MS Excel counts the number of cells in a specified range that contain numerical data only?
A. COUNTA
B. COUNTIF
C. COUNTBLANK
D. COUNT

Correct Answer: Option D


Explanation:
The COUNT function counts cells containing numbers only. COUNTA counts all non-empty cells regardless of data type, and COUNTBLANK counts empty cells.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which of the following is an example of a font style or character decoration attribute?
A. Calibri
B. Margins
C. 12 pt
D. Strikethrough

Correct Answer: Option D


Explanation:
Strikethrough is an explicitly selectable character effect attribute, whereas Calibri is a font family, and 12 pt represents font size metric sizing.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, a circular reference occurs when:
A. A cell reference uses both relative and absolute components
B. A formula references a cell from a different worksheet
C. A formula refers to its own cell either directly or indirectly
D. A cell is formatted as a circle

Correct Answer: Option C


Explanation:
Circular reference means the formula depends on itself, creating an infinite loop.

This question belongs to: Computer Microsoft Office