Mastering SQL Logical Operators

Which SQL logical operator would you use to filter records that meet all specified conditions?

• OR

• AND

• NOT

• LIKE

What is the result of using the OR operator in an SQL query?

• It returns records that meet all conditions.

• It returns records that do not meet any condition.

• It returns records that meet at least one of the conditions.

• It returns records that meet none of the conditions.

Which SQL operator would you use to exclude records that meet a certain condition?

• AND

• OR

• NOT

• BETWEEN

How would you use the BETWEEN filter to select records with a value between 10 and 20?

• WHERE value BETWEEN 10 AND 20

• WHERE value IN (10, 20)

• WHERE value LIKE '10-20'

• WHERE value = 10 OR value = 20

Which SQL filter would you use to select records with a value in a specified list?

• LIKE

• IN

• BETWEEN

• NOT

How would you use the LIKE operator to find records where a column starts with the letter 'A'?

• WHERE column LIKE 'A%'

• WHERE column LIKE '%A'

• WHERE column LIKE '_A_'

• WHERE column LIKE 'A'

Which of the following SQL statements correctly uses the AND operator?

• SELECT * FROM table WHERE column1 = 'value1' OR column2 = 'value2'

• SELECT * FROM table WHERE column1 = 'value1' AND column2 = 'value2'

• SELECT * FROM table WHERE column1 = 'value1' NOT column2 = 'value2'

• SELECT * FROM table WHERE column1 = 'value1' LIKE column2 = 'value2'

What does the following SQL statement do? `SELECT * FROM table WHERE NOT column = 'value';`

• Selects all records where column equals 'value'

• Selects all records where column does not equal 'value'

• Selects all records where column is null

• Selects all records where column is not null

Which SQL statement uses the IN filter correctly?

• SELECT * FROM table WHERE column IN ('value1', 'value2')

• SELECT * FROM table WHERE column BETWEEN 'value1' AND 'value2'

• SELECT * FROM table WHERE column LIKE 'value1' OR 'value2'

• SELECT * FROM table WHERE column NOT IN 'value1', 'value2'

How would you use the LIKE operator to find records where a column contains the substring 'abc'?

• WHERE column LIKE 'abc%'

• WHERE column LIKE '%abc%'

• WHERE column LIKE '_abc_'

• WHERE column LIKE 'abc'