QUESTION 4 Match each term on the left with its definition or purpose on the right:...

Transcribed Image Text:

QUESTION 4 Match each term on the left with its definition or purpose on the right: B. Distinct C. AND D. OR IN BETWEEN G. E. LIKE REGEX 1.IS NULL C. NOT CONCAT QUESTIONE A. matches a column that has no value. B. Returns each value only one time - eliminates duplicates. C. negates the condition (i.e. makes a true statement false and a false statement true). D. combines column vaues together into a single returned value. E. matches a partial string using wildcards. F. Used to match to a list of values separated by commas. G. matches to a range of values H. Used in a where clause for multiple conditions. Returns a row if either condition is true. 1. matches to a pattern such as for an email address or phone number J. Used in a where clause for multiple conditions. Both conditions must be met for the row to be returned. QUESTION 4 Match each term on the left with its definition or purpose on the right: B. Distinct C. AND D. OR IN BETWEEN G. E. LIKE REGEX 1.IS NULL C. NOT CONCAT QUESTIONE A. matches a column that has no value. B. Returns each value only one time - eliminates duplicates. C. negates the condition (i.e. makes a true statement false and a false statement true). D. combines column vaues together into a single returned value. E. matches a partial string using wildcards. F. Used to match to a list of values separated by commas. G. matches to a range of values H. Used in a where clause for multiple conditions. Returns a row if either condition is true. 1. matches to a pattern such as for an email address or phone number J. Used in a where clause for multiple conditions. Both conditions must be met for the row to be returned.