Which SQL clause is used to filter groups after grouping? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL clause is used to filter groups after grouping?

A. HAVING

B. WHERE

C. ORDER BY

D. GROUP BY

Answer: Option A

Solution (By JKSSB Mock Tests)

HAVING is used to filter groups based on aggregate conditions, applied after GROUP BY.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

A view in DBMS is:

A. An index on the table

B. A physical copy of the table

C. A backup of the database

D. A virtual table based on the result of a query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A view is a virtual table derived from one or more base tables.

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is the term for a column in a database table?

A. Relation

B. Attribute

C. Tuple

D. Entity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An attribute is a column or field in a table, representing a property of the entity.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?

A. UNDO

B. REVERT

C. ROLLBACK

D. SAVEPOINT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs