What is the command to concatenate fname and lname with a space in between and display the output under the heading of “Full Name”?
Answer options
A
Employee(eid,fname,lname,salary)
B
select fname||’ ’||lname as ‘Full Name’ from employee;
Correct answer: select fname||’ ’||lname as ‘Full Name’ from employee;
Explanation
The source marks the correct answer as: select fname||’ ’||lname as ‘Full Name’ from employee;.