Which join type in an MS Access Query design view extracts only the rows where the linked key field values match exactly between both tables? MCQ with Answer and Explanation

Question

Which join type in an MS Access Query design view extracts only the rows where the linked key field values match exactly between both tables?

A. Right Outer Join

B. Left Outer Join

C. Inner Join

D. Full Cross Join

Answer: Option C

Solution (By JKSSB Mock Tests)

An Inner Join is the default join type in MS Access. It extracts records from linked tables only when the values in the joined fields match exactly.

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

To create a hanging indent in MS Word, press:

A. Ctrl + M

B. Ctrl + Shift + T

C. Tab

D. Ctrl + T

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which of the following shortcuts inserts a line break (soft return) in MS Word?

A. Ctrl + Enter

B. Alt + Enter

C. Enter

D. Shift + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+Enter creates a new line without a new paragraph.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, the formula =A1&B1 will result in:

A. Concatenation of values in A1 and B1 without space

B. Error

C. Logical AND

D. Sum of A1 and B1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
& concatenates text.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs