Question 4A data professional discovers that SUV is spelled SWV in the database column car_types. Which CASE clause will enable them to correct the misspellings?1 pointCASE WHEN car_types = 'SWV' THEN 'SUV'CASE car_types = 'SWV' THEN 'SUV'WHEN CASE car_types = 'SWV' THEN 'SUV'WHEN car_types CASE = 'SWV' THEN 'SUV'

A "City" field has some values written as uppercase and other values as lowercase, as well as inconsistent spellings. Which processes would create a field with uppercase values that are correctly spelled? A) =TRIM B) Replace Values C) =UPPERSelect an answer:B and CA and BA, B, and C

4. When do you use the CASE WHEN function?  A. To perform conditional logic to return different values in a query result.B. To join multiple tables in a query.C. To group rows that have the same values in specified columns into summary rows.D. To sort the result set of a query.

Fill in the blank: A data professional uses the SQL _____ statement to return records that meet conditions by including an if/then statement in a query.1 pointCASEHAVINGWHENCONCAT

A "City" field has some values written as uppercase and other values as lowercase, as well as inconsistent spellings. Which processes would create a field with uppercase values that are correctly spelled?

When using Find and Replace, you want to ensure that your Replace With text uses upper and lower case letters exactly as intended. How can you ensure this?In the Replace With field, type everything in lowercase.In the Replace With field, type everything in uppercase.This will happen by default.