Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 50 of 50

Marks: +1, -0

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?

It executes successfully but no rows updated.
It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.
It gives an error because multiple NVL functions are used in an expression.
It gives an error because NVL function cannot be used with UPDATE.

Go to Question:

Prev Question