You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table that has a column defined as a smallint data type. The table is partitioned on has boundaries of 100 and 1,000. The table must be altered to contain the following partitions:

< 100 >= 100 and < 400 >= 400 and < 700 >= 700 and < 1000 >= 1000 You need to alter the partition function to provide the required partitions. Which code fragment should you use?

Question

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table that has a column defined as a smallint data type. The table is partitioned on has boundaries of 100 and 1,000. The table must be altered to contain the following partitions:

< 100 >= 100 and < 400 >= 400 and < 700 >= 700 and < 1000 >= 1000 You need to alter the partition function to provide the required partitions. Which code fragment should you use?

Accepted Answer

B. ALTER PARTITION FUNCTION MyRangePF1 () SPLIT RANGE (400); GO ALTER

Answer

A. ALTER PARTITION FUNCTION MyRangePF1 () SPLIT RANGE (399); GO ALTER

Answer

C. DROP PARTITION FUNCTION myRangePF1; GO

Answer

D. DROP PARTITION FUNCTION myRangePF1; GO

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table that has a column defined as a smallint data type. The table is partitioned…

Question

Options

How the community answered

Community Discussion