Select the correct answerWhen is the wildcard in WHERE clause used?OptionsAn exact match is necessary for a CREATE statement.An exact match is not possible in a SELECT statement.An exact match is necessary for a SELECT statement.None of the above

The wildcard in a WHERE clause is useful when?1.0 MarksAn exact match is necessary in a SELECT statement.An exact match is not possible in a SELECT statement.An exact match is necessary in a CREATE statement.An exact match is not possible in a CREATE statement.

Select the correct answerWhat does the SQL LIKE operator do?OptionsCompares two values for equalityChecks if a column is emptyCombines multiple conditionsSearches for a specified pattern in a column

When to use SQL WHERE clause?Answer choicesSelect an optionTo limit the column data that are returned.To limit the row data are returned.Both A and B are correctNeither A nor B are correct.

What does the SQL LIKE operator do?OptionsCompares two values for equalityChecks if a column is emptyCombines multiple conditionsSearches for a specified pattern in a column

What does the SQL LIKE operator do?OptionsCompares two values for equalitySearches for a specified pattern in a columnChecks if a column is emptyCombines multiple conditions