Oracle
1Z0-071 · Question #194
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?
The correct answer is B. It executes successfully and updates the records of those employees who have been working in. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt executes successfully but no rows updated.
- BIt executes successfully and updates the records of those employees who have been working in
- CIt gives an error because multiple NVL functions are used in an expression.
- DIt gives an error because NVL function cannot be used with UPDATE.
How the community answered
(21 responses)- A10% (2)
- B81% (17)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.