Contents of the CUSTOMERS table

Note: The ST column name is truncated,this represents the STATE column.
-Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?
A) SELECT LOWER(name)FROM customers;
B) SELECT LOWER(firstname)|| ' ' || LOWER(lastname)FROM customers;
C) SELECT CONCAT(LOWER(firstname),' ',LOWER(lastname))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 will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?
A) ​SELECT LOWER(name)FROM customers; 
B) ​SELECT LOWER(firstname)|| ' ' || LOWER(lastname)FROM customers; 
C) ​SELECT CONCAT(LOWER(firstname),' ',LOWER(lastname))FROM customers; 
D) ​none of the above

Quizplus · Accepted Answer

Since the name column is not mentioned in the question nor exists in the table, the only option is to concatenate the firstname and lastname columns, and convert them to lowercase using the LOWER function. Option B achieves this by concatenating the lowercase versions of the firstname and lastname columns with a space in between. Option A is incorrect because the name column does not exist in the table, and Option C is incorrect because the CONCAT function is not available in all SQL versions.

Contents of the CUSTOMERS Table