Solved

Contents of the CUSTOMERS Table

Question 50

Multiple Choice

Contents of the CUSTOMERS table
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
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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions