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 contains 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. DROP PARTITION FUNCTION myRangePF1; GO
CREATE PARTITION FUNCTION myRangePF1 (smallint)
AS RANGE RIGHT FOR VALUES (99, 399, 699, 999);
B. ALTER PARTITION FUNCTION MyRangePF1 () SPLITRANGE (399); GO
ALTER PARTITION FUNCTION MyRangePF1 () SPLITRANGE (699); GO
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 (400); GO
ALTER PARTITION FUNCTION MyRangePF1 () SPLIT RANGE (700); GO
