Examine these two rows from an employee table: empid empname designation 12330 Scott Manager 10012 King CEO You must display the rows like this: PROFILE Scott is a Manager King is a CEO Which statements do this? (Choose two) SELECT CONCAT(emp_name," is a " + designation)PROFILE FROM emp: SELECT emp_name || 'is a '|| designation AS PROFILE FROM emp: SELECT CONCAT(emp_name, concat(' is a', designation)) PROFILE FROM emp; SELECT CONCAT(empname," is a ", designation) PROFILE FROM emp: SELECT emp_name +' is a' + designation AS PROFILE FROM emp;