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:

Quadriceps

A group of four muscles at the front of the thigh, crucial for walking, running, and jumping.

Quadri-

A prefix meaning four, used in medical terms to denote something relating to four parts or quadrants.

Rotates

The action of an object or part of it turning around its own axis or a central point, which is common in mechanical and anatomical systems.

Deltoid

A large, triangular muscle covering the shoulder joint and used for lifting and rotating the arm.