Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 36

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

Answer options

• A. Evaluate Variable
• B. Set Variable
• C. Declare Variable
• D. Refresh Variable

Correct answer: B

Explanation

The correct answer is B, Set Variable, as it is specifically designed to assign values to variables, including those obtained from SQL queries. The other options do not focus on value assignment: A evaluates a variable, C is for declaring variables, and D refreshes the value of an existing variable.