Contents of the CUSTOMERS Table

question 50

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-Which of the following SQL statements will return an error message,based upon the contents of the CUSTOMERS table?​

• A) ​SELECT CONCAT(firstname,lastname)FROM customers;
• B) ​SELECT INITCAP(lastname),INITCAP(firstname)FROM customers;
• C) ​SELECT LENGTH(customer#)FROM customers;
• D) ​none of the above

---

Definitions:

Profits and Losses

Financial gains or deficits that a business experiences, typically shown in an income statement.

Invests

Invests pertains to the act of committing money or capital to an endeavor with the expectation of obtaining an additional income or profit.

Capital Account

A financial statement that shows the changes in a company’s equity throughout a period, from investments, withdrawals, and net income.

Recording a Bonus

The process of documenting an additional compensation given to employees or stakeholders, over and above their regular earnings.