SQL Server 2008 provides enhanced partitioning information for _______ – McqOptions

MCQOPTIONS

1.	SQL Server 2008 provides enhanced partitioning information for __________ execution plans?
A.	compile-time
B.	run time
C.	both compile-time and run-time
D.	all of the mentioned
Answer» D. all of the mentioned

Discussion

No Comment Found

Related MCQs

WHICH_OF_THE_FOLLOWING_PARTITIONED_ATTRIBUTE_CAN_APPEAR_IN_THE_FOLLOWING_PHYSICAL_AND_LOGICAL_OPERATORS_??$
The_query_processor_uses_a____________execution_strategy_for_queries_that_select_from_partitioned_objects.$
SQL Server 2008 provides enhanced partitioning information for __________ execution plans?
With a larger number of partitions, ______ commands could take longer to execute as the number of partitions increases.
At least _______ of RAM is recommended if a large number of partitions are in use.
Designing an nonaligned partitioned index can be useful in the following case :
__________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column
SQL Server 2014 supports up to ________ partitions by default.