Oracle
1Z0-146 · Question #29
View Exhibit1 and examine the structure of the EMPLOYEES table. View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in…
The correct answer is C. It executes successfully only if department ID 60 has five or less than five employees. See the full explanation below for the reasoning.
Question
View Exhibit1 and examine the structure of the EMPLOYEES table. View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60. Which statement is true about the outcome?
Exhibits
Options
- AIt generates an error because RECORD type cannot be used with varrays.
- BIt generates an error because BULK COLLECT cannot be used with varrays.
- CIt executes successfully only if department ID 60 has five or less than five employees.
- DIt executes successfully even if department ID 60 has more than five employees by dynamically
How the community answered
(13 responses)- B8% (1)
- C77% (10)
- D15% (2)
Community Discussion
No community discussion yet for this question.