Question 11


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:

  • Chapter 2, "Creating Database Objects," and Chapter 3, "Implementing Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Language Reference, Transact-SQL Reference, $PARTITION (Transact-SQL)"

  • "Partitioned Tables and Indexes in SQL Server 2005," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5partition.asp

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, Partitioned Tables and Indexes in SQL Server 2005.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net