In MS Access, which clause of SQL is used to filter records based on a condition? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, which clause of SQL is used to filter records based on a condition?

A. HAVING

B. GROUP BY

C. ORDER BY

D. WHERE

Answer: Option D

Solution (By JKSSB Mock Tests)

WHERE filters rows before grouping. HAVING filters after grouping.

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

Which command feature in MS Word is used to replace misspelled words automatically with pre-programmed choices while typing?

A. AutoText

B. Smart Lookup

C. AutoCorrect

D. Track Changes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AutoCorrect corrects typos, misspelled words, and syntax automatically using a pre-defined database list of common mistakes.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to find the largest value that meets a condition?

A. MAXIFS

B. MAXA

C. LARGE

D. MAX

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MAXIFS returns the maximum value based on criteria.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, the feature that automatically creates a border when you type three hyphens and press Enter is:

A. Quick Styles

B. AutoCorrect

C. AutoFormat As You Type

D. Smart Lookup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Typing three hyphens, underscores, or equal signs and Enter triggers automatic border creation.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs