Question 30


Answer C is correct. Float gives accuracy up to 308 decimal places, which is almost 10 times better than can be achieved with any of the other types. The real and decimal data types provide only 38 decimal places of accuracy at most, and money and smallmoney have accuracy to only the ten-thousandths.

For more information, see the following sources:

  • Chapter 1, "Installing and Configuring SQL Server 2005," and Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "Transact-SQL Reference, Data Types"




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

Similar book on Amazon

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