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?

The correct answer is D. **17000.00. See the full explanation below for the reasoning.

Question

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?

(23 responses)

No community discussion yet for this question.