Contents of the CUSTOMERS Table

question 90

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

• A) ​SELECT LOWER(name)FROM customers;
• B) ​SELECT LOWER(firstname)|| ' ' || LOWER(lastname)FROM customers;
• C) ​SELECT CONCAT(LOWER(firstname),' ',LOWER(lastname))FROM customers;
• D) ​none of the above

---

Definitions:

Well-child Checkup

Regularly scheduled medical visits aimed at monitoring and promoting the healthy development of children.

Security Object

An item, often a blanket or toy, that provides comfort to a child in potentially stressful or unfamiliar situations.

Examining Table

A piece of medical equipment used in healthcare settings for patient assessment, allowing for various positions during examination.

Shortness of Breath

A sensation of not being able to breathe well enough, a common symptom of heart or lung conditions.