In MS Access, a unique key that prevents duplicate entries and uniquely distinguishes each record or row in a table database is known as the: MCQ with Answer and Explanation

In MS Access, a unique key that prevents duplicate entries and uniquely distinguishes each record or row in a table database is known as the:
A. Candidate Key
B. Foreign Key
C. Primary Key
D. Composite Key
Answer: Option C
Solution (By JKSSB Mock Tests)
The Primary Key is a field or combination of fields that uniquely identifies each record in an Access table and cannot contain null or duplicate values.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which of the following function syntaxes is correct in MS Excel to extract the current system date alone, without any time stamps?
A. =TODAY()
B. =CURRENTDATE()
C. =NOW()
D. =DATEVALUE(NOW)

Correct Answer: Option A


Explanation:
=TODAY() returns the current system date as a serial number date format without any time data, whereas =NOW() returns both the current date and time.

This question belongs to: Computer Microsoft Office
Question #2
Which of the following is a type of animation in PowerPoint?
A. Design Template
B. Motion Paths
C. Slide Transition
D. Slide Master

Correct Answer: Option B


Explanation:
Motion Paths are animation effects for objects. Transition is not an animation category.

This question belongs to: Computer Microsoft Office
Question #3
Which key is used to rename a selected slide in PowerPoint slide pane?
A. F5
B. Ctrl + R
C. Alt + R
D. F2

Correct Answer: Option D


Explanation:
F2 allows renaming of the selected object or, in some contexts, the slide (by selecting slide title). However, F2 in thumbnail pane doesn't rename; but it's standard rename key. Actually, to rename a slide in PowerPoint, you can right-click and Rename, no direct shortcut. But F2 is generally Rename in Office. I'll avoid this ambiguity. Better question: In Excel, F2 edits cell. I'll replace. I'll skip this and create another. Need 300, I'll replace with a valid question. I'll do: In MS Access, what is the maximum size of a database? A) 2 GB, B) 1 GB, C) 4 GB, D) 500 MB. Actually, Access 2016 max is 2 GB. So that's ok. I'll replace question.

This question belongs to: Computer Microsoft Office