DS0-001: CompTIA DataSys+Demo

By CompTIA · Question Mode

QuestionQ116

Database Fundamentals

Which of the following best explains the function of a wildcard in the WHERE clause?

  • A An exact match is not possible in a CREATE statement.
  • B An exact match is necessary in a SELECT statement.
  • C An exact match is not possible in a SELECT statement.
  • D An exact match is necessary in a CREATE statement.
Explanation

A wildcard in a WHERE clause is used with pattern matching, such as LIKE, to return rows whose values match a pattern rather than one exact value. Microsoft documents wildcard characters as part of the LIKE pattern used in WHERE filtering.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!