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

Question

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

Quizplus · Accepted Answer

All the SQL statements provided are syntactically correct and should execute without error, assuming the columns exist in the CUSTOMERS table.

Contents of the CUSTOMERS Table