Which three statements are true about the interpretatio…

Which three statements are true about the interpretation of an execution plan? (Choose three.)

Which three statements are true about the interpretation of an execution plan? (Choose three.)

A.
The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU
resources.

B.
The ROWS column indicates the cardinality of each operation and is always calculated by dividing the totalnumber of rows in the table by the number of distinct values in the column used in the WHERE clause
predicate.

C.
A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index
exists for the filter column.

D.
An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.

E.
A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.



Leave a Reply 0

Your email address will not be published. Required fields are marked *