With a larger number of partitions, ______ commands could take longer – McqOptions

MCQOPTIONS

1.	With a larger number of partitions, ______ commands could take longer to execute as the number of partitions increases.
A.	DML
B.	DDL
C.	DBCC
D.	TCL
Answer» D. TCL

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.