[Check Point 12.1] Simple Queries in SQL – Chapter 12 Sumita Arora

11. Which operator concatenates two strings in a query result?

Solution: The “CONCAT” operator concatenates two or more strings in a query result.

12. Which comparison operator is used for comparing?
(i) patterns
(ii) character values
(iii) null values
(iv) ranges
(v) list of values.

Solution:

1. Patterns: “LIKE” operator.
2. Character values: “=” operator.
3. Null values: “IS NULL” or “IS NOT NULL” operators.
4. Ranges: “BETWEEN” operator.
5. List of values: “IN” operator.