Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition? MCQ with Answer and Explanation

Question

Share Report Error

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. GROUP BY

B. ORDER BY

C. WHERE

D. HAVING

Answer: Option C

Solution (By JKSSB Mock Tests)

The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

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

What is a primary key in a database table?

A. A key that references a column in another table

B. A key that can contain duplicate values

C. A key that is always numeric

D. A key that uniquely identifies each row in a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A primary key is a column or set of columns that uniquely identifies each row in a table, ensuring entity integrity.

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

Question #2

Which of the following is true about a surrogate key?

A. It is a natural key derived from the data

B. It is a composite key

C. It is an artificial key, usually an auto-increment integer, with no business meaning

D. It is a foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A surrogate key is a system-generated unique identifier, typically numeric, that has no business significance.

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

Question #3

Which statement about primary keys in a relational database table is completely true?

A. Primary keys must always be numeric integers.

B. A table can contain at most one primary key.

C. A primary key column can accept a single NULL value.

D. A table can have multiple distinct primary keys.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A relational database table can have exactly one primary key constraint defined, which uniquely identifies each record and strictly forbids NULLs.

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

Explore All Database Management System (DBMS) MCQs