View the Exhibit and examine the data in the EMPLOYEES table.
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
What is the outcome?
A. It generates an error because the alias is not valid.
B. It executes successfully and gives the correct output.
C. It executes successfully but does not give the correct output.
D. It generates an error because the usage of the ROUND function in the expression is not valid.
E. It generates an error because the concatenation operator can be used to combine only two items.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Correct: A
ORA-00923: FROM keyword not found where expected
SELECT ename ‘joined on’ hiredate’, the total compensation paid is’ TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365)*sal + comm) “COMPENSATION UNTIL DATE” FROM employees;
Concatenation looks wrong
Is the answer correct?
The final TO_CHAR will not execute the operations inside, it will just show the operation