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.
17000.00
B.
17000*****
C.
****170.00
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.
17000.00
B.
17000*****
C.
****170.00
D.
**17000.00
E.
an error statement
D