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:

Vendor

An individual or company offering goods or services for sale.

Encroachments

Unauthorized intrusion or extension of a building, structure, or other improvement onto another's property.

Easements

A legal right to use another person's land for a specific limited purpose, such as right of way or utility access, without owning it.

Physical Boundary

The real, tangible boundaries that define the perimeter of a property, often marked by fencing, walls, or natural landmarks.