Oracle
1Z0-147 · Question #51
Your company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store the results in the…
The correct answer is C. You need to give the arithmetic expression that involves the salary increment in the SELECT clause of the SELECT statement. See the full explanation below for the reasoning.
Question
Your company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store the results in the database, which statement is valid?
Options
- AYou need to add a column to the EMP table.
- BYou need to give the arithmetic expression that involves the salary increment in the SET clause of the UPDATE statement.
- CYou need to give the arithmetic expression that involves the salary increment in the SELECT clause of the SELECT statement.
- DYou need to give the arithmetic expression that involves the salary increment in the UPDATE clause of the SELECT statement.
- EYou need to give the arithmetic expression that involves the salary increment in the DISPLAY clause of the SELECT statement.
How the community answered
(23 responses)- A13% (3)
- C78% (18)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.