Asked by Wendy Reynoso on Jun 08, 2024
Verified
What data type is most appropriate for a field named PaymentAmt?
A) Number
B) Currency
C) AutoNumber
D) Input Mask
Number
A mathematical object used to count, measure, and label.
Currency
A system of money in general use in a particular country or economic context, also used in various applications to define monetary values.
PaymentAmt
A variable, field, or term typically used in financial transactions representing the amount of payment to be made.
- Ascertain the proper data categories and field characteristics for maintaining diverse types of data in a database.
Verified Answer
EN
emelly navarreteJun 09, 2024
Final Answer :
B
Explanation :
The field name "PaymentAmt" suggests that it will contain monetary values, making the Currency data type the most appropriate choice. This data type is specifically designed for storing and performing calculations with monetary data.
Learning Objectives
- Ascertain the proper data categories and field characteristics for maintaining diverse types of data in a database.