Answer D is correct. The $PARTITION function is used for querying by partition number. The ROWGUIDCOL column can be referenced in a SELECT list by using the $ROWGUID keyword. This is similar to the way an IDENTITY column can be referenced by using the $IDENTITY keyword. sp_spaceused displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Broker queue. sp_table_validation either returns row count or checksum information on a table or an indexed view, or it compares the provided row count or checksum information with the specified table or indexed view. sp_server_info returns a list of attribute names and matching values for SQL Server. For more information, see the following sources:
|