Oracle
1Z0-071 · Question #56
Evaluate the following two queries: Which statement is true regarding the above two queries?
The correct answer is B. There would be no change in performance. See the full explanation below for the reasoning.
Question
Evaluate the following two queries:
Which statement is true regarding the above two queries?
Exhibit
Options
- APerformance would improve query 2 only if there are null values in the CUST__CREDIT__LIMIT
- BThere would be no change in performance.
- CPerformance would degrade in query 2.
- DPerformance would improve in query 2.
How the community answered
(36 responses)- A3% (1)
- B78% (28)
- C14% (5)
- D6% (2)
Community Discussion
No community discussion yet for this question.