Contents of the CUSTOMERS Table

question 79

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table?

• A) ​SELECT INITCAP(firstname,lastname)FROM customers;
• B) ​SELECT LENGTH (city,state,zip)FROM customers;
• C) ​SELECT customer#,NVL2(referred,'Referred','Not Referred')FROM customers;
• D) ​SELECT INITCAP((firstname), ( lastname))FROM customers;

---

Definitions:

Gender Awareness

The understanding and recognition of gender and its societal roles and norms, beginning at an early age.

Initiative V. Guilt

A stage in Erik Erikson's theory of psychosocial development where young children learn to assert control and power over their environment or experience guilt for their efforts.

Egalitarian

A belief or doctrine that emphasizes equality, especially regarding moral, political, social, and economic rights for all humans.

Sensitivity

The quality of being easily influenced, changed, or affected by external conditions or stimuli.