Evaluate the SQL statement: SELECT LPAD (salary,10,’*’) FROM EMP WHERE EMP_ID =
1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
A.
****170.00
B.
**17000.00
C.
17000*****
D.
17000.00
E.
an error statement
Evaluate the SQL statement: SELECT LPAD (salary,10,’*’) FROM EMP WHERE EMP_ID =
1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
Evaluate the SQL statement: SELECT LPAD (salary,10,’*’) FROM EMP WHERE EMP_ID =
1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
A.
****170.00
B.
**17000.00
C.
17000*****
D.
17000.00
E.
an error statement