CompTIA Data+ Study Guide

AppendixAnswers to the Review Questions

Chapter 2: Understanding Data

1. D. While UA 769 contains numeric and text components, selecting an alphanumeric data type is the best option if you store this information in a single field. Since there is no date information contained in UA 769, the date data type is not appropriate.
2. C. Voice transcripts are unstructured digital audio files. As such, the BLOB data type is the only viable choice. The alphanumeric, numeric, and date data types are all structured data types.
3. D. In order to facilitate precise mathematical operations on financial data, a numeric data type is the most appropriate choice. Smallmoney does not support values in excess of $1 million. Both smallmoney and money are subject to ...