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. ORDER BY

B. GROUP BY

C. WHERE

D. HAVING

Answer: Option C

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

What is the maximum zoom percentage scale allowed natively in Microsoft Word?

A. 400%

B. 1000%

C. 200%

D. 500%

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MS Word allows a maximum document zoom scale of 500%, whereas MS Excel and PowerPoint are capped at 400%.

This question belongs to: Computer Microsoft Office

Question #2

In Access, which of the following is used to create a backup of a database?

A. Database Tools > Backup

B. File > Save As > Back Up Database

C. File > Export > Backup

D. Home > Backup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In Access, you can back up via File > Save As > Back Up Database.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20?

A. =IF(A1>10, A1<20)

B. =AND(A1>10, A1<20)

C. =OR(A1>10, A1<20)

D. =NOT(A1>10)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AND returns TRUE if all conditions are true.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs