Explanation:When an operator such as an Index Seek is executed on a partitioned table or index, the Partitioned attribute appears in the compile-time and run-time plan and is set to True. 10. The query processor uses a __________ execution strategy for queries that select from partitioned objects.
A. distributed
B. parallel
C. lock
D. None of the mentioned
Answer:A
Explanation:When an operator such as an Index Seek is executed on a partitioned table or index, the Partitioned attribute appears in the compile-time and run-time plan and is set to True. 10. The query processor uses a __________ execution strategy for queries that select from partitioned objects.
A. distributed B. parallel C. lock D. None of the mentioned
Explanation:As part of the execution strategy, the query processor determines the table partitions required for the query and the proportion of threads to allocate to each partition. Sanfoundry Global Education & Learning Series – SQL Server.