Oracle
1Z0-064 · Question #76
Which three statements are true about the interpretation of an execution plan? (Choose three.)
The correct answer is B. The ROWS column indicates the cardinality of each operation and is always calculated by D. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be E. A HASH JOIN in the Operation column always implies that two tables are joined by using an. See the full explanation below for the reasoning.
Question
Which three statements are true about the interpretation of an execution plan? (Choose three.)
Options
- AThe cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU
- BThe ROWS column indicates the cardinality of each operation and is always calculated by
- CA TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only
- DAn INDEX UNIQUE SCAN in the Operation column always implies that only one row will be
- EA HASH JOIN in the Operation column always implies that two tables are joined by using an
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C12% (3)
Community Discussion
No community discussion yet for this question.