In a query, using the keyword _______________ will return records in which the field value is between two numbers. A. Between B. Is Null C. Like D. Not

The correct answer is: Between

The keyword Between is used in a query to

SELECT * FROM table WHERE Age BETWEEN 18 AND 65;

The keyword Is Null is used to test whether a field is null. For example, the following query will return all records in which the Age field is null:

SELECT * FROM table WHERE Age IS NULL;

The keyword Like is used to match a field value against a pattern. For example, the following query will return all records in which the Name field contains the string “John”:

SELECT * FROM table WHERE Name LIKE '%John%';

The keyword Not is used to negate a condition. For example, the following query will return all records in which the Age field is not null:

SELECT * FROM table WHERE Age NOT IS NULL;