PL: Q1-Lesson 4 IT2101

What does the LIKE operator in MySQL do?

• Check if a value lies within a specified range

• Filter results by matching against a list of values

• Search for a specified pattern in a column

• Combine result sets of multiple SELECT statements

Which wildcard character in the LIKE operator represents a single character?

• #

• ?

• _

• %

What is the purpose of the IN operator in MySQL?

• To filter results by a specified range

• To filter results by checking if a value exists in a set

• To combine multiple SELECT statements into one

• To check if a subquery returns any rows

Which operator is used to check if a value lies within a specified range?

• BETWEEN

• IN

• LIKE

• UNION

What does the UNION operator do in MySQL?

• Filters results based on a subquery

• Combines result sets of two or more SELECT statements

• Matches a column's value against a pattern

• Checks if a value exists in a list

What is the function of the EXISTS operator?

• To combine multiple SELECT statements

• To check if a subquery returns any rows

• To perform pattern matching in strings

• To filter results by a specified range

Which operator can be used with both numeric and text data?

• UNION

• EXISTS

• BETWEEN

• LIKE

What does the '%' wildcard represent in the LIKE operator?

• Zero, one, or multiple characters

• A specific character

• A single character

• No characters

Which operator is particularly useful for simplifying multiple OR conditions?

• LIKE

• BETWEEN

• IN

• UNION

What does the UNION ALL operator do?

• Removes duplicate rows from the result set

• Includes duplicates in the result set

• Filters results based on a subquery

• Checks if a value exists in a list