Depending on the employee that has the following columns :Empno number(4) ,emp_name varchar2(20), salary number(5,2).job varchar2(10)....

 

Transcribed Image Text:

Depending on the employee that has the following columns :Empno number(4) ,emp_name varchar2(20), salary number(5,2).job varchar2(10). To list employee names job and yearly salary for all employees: a. Yearly salary Is not a column in table ,can not use select. O b. SELECT emp_namejob,salary*12 "yearly Salary" from EMPLOYEE c. SELECT emp_name,salary from EMPLOYEE where yearly salary=12 O d. SELECT job, salary/12 from EMPLOYEE Depending on the employee that has the following columns :Empno number(4) ,emp_name varchar2(20), salary number(5,2).job varchar2(10). To list employee names job and yearly salary for all employees: a. Yearly salary Is not a column in table ,can not use select. O b. SELECT emp_namejob,salary*12 "yearly Salary" from EMPLOYEE c. SELECT emp_name,salary from EMPLOYEE where yearly salary=12 O d. SELECT job, salary/12 from EMPLOYEE