Oracle
1Z0-071 · Question #35
View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the…
The correct answer is D. Both statements 1 and 2 execute successfully and give the same required result. See the full explanation below for the reasoning.
Question
View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the following two SQL statements:
Which statement is true regarding the outcome?
Exhibits
Options
- AOnly statement 1 executes successfully and gives the required result.
- BOnly statement 2 executes successfully and gives the required result.
- CBoth statements 1 and 2 execute successfully and give different results.
- DBoth statements 1 and 2 execute successfully and give the same required result.
How the community answered
(37 responses)- A3% (1)
- B5% (2)
- C11% (4)
- D81% (30)
Community Discussion
No community discussion yet for this question.