You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The SQL Server 2008 R2 instance includes a database that has a table, named ABC_Tbl, which is
partitioned on the ProID column. The partitioning characteristics are as follows:
•Partition 1 includes integer values between 5 and 30,000.
•Partition 2 includes integer values in excess of 30,000.
Due to the growth in business operations, ABC.com foresees the need to have a third partition in
the table.
You receive instructions to create a third partition on the table. This partition must be able to
include the integer values in excess of 60,000.
You decide to make use of an ALTER PARTITION FUNCTION Transact-SQL statement.
Which of the following is TRUE with regards to this Transact-SQL statement? (Choose all that
apply.)
A.
It can only be used for splitting one partition into two, or merging two partitions into one.
B.
It adds a filegroup to a partition scheme or alters the designation of the NEXT USED filegroup
for the partition scheme.
C.
Filegroups that are affected by ALTER PARITITION FUNCTION does not have to be online.
D.
ALTER PARTITION FUNCTION continues to process, even if there is a disabled clustered
index on any tables that use the partition function.
Explanation: