In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.
Evaluate the following SQL statement:
What would be the result?
A. It executes successfully but no rows updated.
B. It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.
C. It gives an error because multiple NVL functions are used in an expression.
D. It gives an error because NVL function cannot be used with UPDATE.
|
Download Printable PDF. VALID exam to help you PASS. |
 |