nerdexam
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)
  • A
    4% (1)
  • B
    7% (2)
  • C
    4% (1)
  • D
    71% (20)
  • E
    14% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice