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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

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 total number 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply