Ace the A Level Computer Science OCR 2026 – Code Your Way to Success!

Question: 1 / 400

In SQL, which statement indicates that both conditions must be true?

OR

AND

The statement that indicates that both conditions must be true is represented by the logical operator AND in SQL. When using AND between two conditions in a query, it ensures that the result set includes only those records where both specified conditions are met.

For instance, if you write a SQL clause such as `WHERE condition1 AND condition2`, the database will return rows only when both condition1 and condition2 evaluate to true. This operator is foundational in SQL for filtering data, as it allows for more precise and specific queries by combining multiple criteria that must all hold true simultaneously.

The other options serve different purposes: OR allows either condition to be true for a record to be included, NOT negates a condition rather than combining conditions, and IF is a control flow statement rather than a logical operator for combining conditions in a WHERE clause.

Get further explanation with Examzify DeepDiveBeta

NOT

IF

Next Question

Report this question

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy