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 the basis of the smallint column. The partition function, named
MyRangePF1, is a range-right function that 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?

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

B.
DROP PARTITION FUNCTION myRangePF1; GO CREATE PARTITION FUNCTION
myRangePF1 (smallint) AS RANGE RIGHT FOR VALUES (99, 399, 699, 999);

C.
DROP PARTITION FUNCTION myRangePF1; GO CREATE PARTITION FUNCTION

myRangePF1 (smallint) AS RANGE LEFT FOR VALUES (100, 400, 700, 1000);

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