Contents of the CUSTOMERS Table

question 68

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as:
City,State Zip​

• A) SELECT INITCAP(CONCAT(city,CONCAT(',',CONCAT(state, CONCAT(' ',zip))))) FROM customers;
• B) SELECT CONCAT(city,CONCAT(',',CONCAT(state, CONCAT(' ',CONCAT(zip))))) FROM customers;
• C) SELECT INITCAP(CONCAT(city,',',state,' ',zip)) FROM customers;
• D) ​none of the above

---

Definitions:

Toxic Compound

A chemical substance known to cause harm to organisms through its chemical action when ingested, inhaled, or comes into contact with skin.

Insecticide

Substances used to kill or control the population of insects, typically used in agriculture and household pest control.

Pathogen

An organism, typically a bacterium, virus, or other microorganism, that can cause disease in its host.

Inhalation

The act of breathing in; drawing air or other substances into the lungs.