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

Question Report Error

Which SQL clause is used to filter groups after grouping?

A. GROUP BY

B. ORDER BY

C. WHERE

D. HAVING

Answer: Option D

Solution (By JKExamLibrary)

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

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?

A. Field

B. Database

C. Information

D. Raw facts

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

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

Question #2 Report Error

Which of the following is a characteristic of a DBMS?

A. Data redundancy control

B. Security and access control

C. All of the above

D. Data independence

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

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

Question #3 Report Error

What does the ROLLBACK statement do?

A. Creates a savepoint

B. Saves the changes

C. Undoes all changes made in the current transaction

D. Starts a new transaction

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.

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

Explore All Database Management System (DBMS) MCQs