Oracle
1Z0-061 · Question #257
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?
Options
- A17000.00
- B17000*****
- C****170.00
- D**17000.00
- Ean error statement
How the community answered
(28 responses)- A4% (1)
- B7% (2)
- C4% (1)
- D71% (20)
- E14% (4)
Community Discussion
No community discussion yet for this question.