Contents of the CUSTOMERS Table

question 94

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

• A) SELECT customer#,city,SUBSTR(state,'FL','FLORIDA')FROM customers WHERE state = 'FL';
• B) SELECT customer#,city,SUBSTR( 'FL','FLORIDA')FROM customers WHERE state = 'FL';
• C) SELECT customer#,city,REPLACE( 'FL','FLORIDA')FROM customers WHERE state = 'FL';
• D) SELECT customer#,city,REPLACE(state,'FL','FLORIDA')FROM customers WHERE state = 'FL';

---

Definitions:

Turnover

The rate at which employees leave a company and are replaced by new employees, often a reflection of the organization's health and workplace satisfaction.

Job Satisfaction

A measure of how content an individual is with their job, encompassing aspects such as work environment, pay, and personal fulfillment.

Marriott Hotels

A multinational company that operates, franchises, and licenses lodging including hotel, residential, and timeshare properties.

Breakfast Room Service

A service offered by hotels where guests can have their breakfast delivered to their room instead of eating in the hotel's dining area.