Oracle MySQL 8.0 Database Developer 1z0-909 Question # 10 Topic 2 Discussion

Oracle MySQL 8.0 Database Developer 1z0-909 Question # 10 Topic 2 Discussion

1z0-909 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

You must write a statement that combines the first_name and last_name columns from the

employees table as "last_name, first_name."

Which two statements will do this?


A.

SELECT last_name + ', ' + first_name FROM employees;


B.

SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;


C.

SELECT GROUP_CONCAT(last_name, first_name) FROM employees;


D.

SELECT last_name, ‘ , ',first_name FROM employees;


E.

SELECT CONCAT(last name,', ',first_name) FROM employees;


Get Premium 1z0-909 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.