MCQ | SQL – Pattern Matching

by karimhani25
73
9

Sql programming

questions

Title
Which of the following is TRUE about Pattern Matching in SQL? Which of the following is TRUE about Pattern Matching in SQL? In SQL, pattern matching is performed with LIKE clauses. An SQL query usually begins with a LIKE clause before a WHERE clause Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table. All of the above discuss The answer is: D. All of the above
It is possible to use LIKE clauses with – It is possible to use LIKE clauses with – Strings Numbers Both A. and B. None of the above discuss The answer is: C. Both A. and B.
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used In LIKE clause, to represent a zero, a character, or a number of characters ___ is used. / _ * % discuss The answer is: D. %
In LIKE clause, to represent a single character, _____ is used In LIKE clause, to represent a single character, _____ is used. - _ ! & discuss The answer is: B. _
LIKE clause can be used with – LIKE clause can be used with – % operator _ operator NOT operator All of the above discuss The answer is: D. All of the above
What does the following statement do? What does the following statement do? `WHERE CustomerName LIKE 'a%'` Finds any values that start with \ Finds any values that start with \ Finds any values that contains only two characters starting with \ All of the above discuss The answer is: B. Finds any values that start with \
What does the following statement do? What does the following statement do? `WHERE CustomerName LIKE '%a'` Finds any values that end with "a" Finds any values whose second character is "a" Find any values that contains only two characters ending with "a" Mysql > Savepoint ini; discuss The answer is: A. Finds any values that end with "a"
What does the following statement do? What does the following statement do? `WHERE CustomerName LIKE '%or%'` Finds any values that start with "or" Finds any value that contains only four characters and second, third characters are 'o', 'r' Finds any values that have "or" in any position None of the above discuss The answer is: C. Finds any values that have "or" in any position
What does the following statement do? What does the following statement do? `WHERE ContactName LIKE 'a%o'` Finds any values that start with "a" and ends with "o" Finds any values whose first character is "a" and third character is "o" Both A. and B. None of the above discuss The answer is: A. Finds any values that start with "a" and ends with "o"

total MCQs: 9

MCQs

9

Views

73

Best Answers

299

Points

5