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. Inner Join

B. Full Cross Join

C. Left Outer Join

D. Right Outer Join

Answer: Option A

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

In MS Access, the default name of the first table created in a blank database is:

A. MainTable

B. Default

C. NewTable

D. Table1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Access names new table Table1.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, what is the default number format for cells?

A. General

B. Text

C. Number

D. Custom

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
General is the default format.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function is used to return the smallest value that meets a condition?

A. SMALL

B. MIN

C. MINIFS

D. MINA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs