Explanation:Execution plans now provide an optional Partitioned attribute that indicates that an operator, such as a seek, scan, insert, update, merge, or delete, is performed on a partitioned table. 9. Which of the following partitioned attribute can appear in the following physical and logical operators ?
A. Index Seek
B. Drop
C. Alter
D. None of the mentioned
Answer:A
Explanation:Execution plans now provide an optional Partitioned attribute that indicates that an operator, such as a seek, scan, insert, update, merge, or delete, is performed on a partitioned table. 9. Which of the following partitioned attribute can appear in the following physical and logical operators ?
A. Index Seek B. Drop C. Alter D. None of the mentioned
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.