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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
answer should be *****17000
so the answer shuld be “E” an error statement.
because if we run the statement, we get this message.
ORA-00936
missing apostrophes
If we use single quotation mark on both side of * symbol –> ‘*’ the result is: *****17000
it actually not true. if we run this statement we get *****17000, so the answer is D