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
Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?
A. GROUP BY
B. HAVING
C. ORDER BY
D. WHERE
Answer: Option D
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
RDBMS is based on which model?
A. Hierarchical model
B. Relational model
C. Object-oriented model
D. Network model
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the main purpose of indexing in a database?
A. To encrypt data
B. To speed up data retrieval
C. To delete data
D. To backup data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Indexes improve the speed of data retrieval operations on a database table.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a database lock?
A. A type of index
B. A mechanism to prevent simultaneous access to the same data causing inconsistency
C. A backup file
D. A user account
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: