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

In MS Access, which clause of SQL is used to filter records based on a condition?
A. GROUP BY
B. ORDER BY
C. HAVING
D. WHERE
Answer: Option D
Solution (By JKSSB Mock Tests)
WHERE filters rows before grouping. HAVING filters after grouping.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, which function is used to calculate the number of periods for a loan?
A. RATE
B. NPER
C. PMT
D. PV

Correct Answer: Option B


Explanation:
NPER calculates the number of payment periods.

This question belongs to: Computer Microsoft Office
Question #2
What is the default orientation of slides in MS PowerPoint?
A. Portrait
B. Square
C. Landscape
D. Widescreen

Correct Answer: Option C


Explanation:
The default slide orientation is Landscape (wider than tall). Portrait is available but not default.

This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is a valid expression for a query criterion?
A. Between #1/1/2020# And #12/31/2020#
B. >100
C. Like 'S*'
D. All of the above

Correct Answer: Option D


Explanation:
All are valid criteria expressions in Access queries.

This question belongs to: Computer Microsoft Office