A Level Computer Science OCR Practice Exam

What type of statement does the SQL WHERE clause use for filtering records?

1. Integer statements

2. Boolean statements

3. String statements

4. Date statements

The correct answer is: Boolean statements

The SQL WHERE clause is designed to filter records based on specified conditions. It relies on Boolean statements to determine whether a row should be included in the results of a query. In a WHERE clause, the expression evaluates to either true or false: if the expression evaluates to true, the record is selected; if false, it is excluded. For example, a typical WHERE clause might be constructed like this: ```sql SELECT * FROM Employees WHERE Age > 30; ``` In this case, the condition "Age > 30" is a Boolean statement that evaluates whether the age of each employee is greater than 30. If the condition is true, that employee's record will be included in the results. This focus on true or false evaluations is foundational to how filtering works in SQL. Other types of statements such as integer, string, or date are specific data types but do not represent the logical evaluation needed for filtering records.