Question

Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name).

A) captionB) detailsC) formatD) index

Answer 1

Option A Caption

Step-by-step explanation:

Caption is a direct and short description about the field that provide more contextual info about the field. For example, if a target field is expected to store a last name value, we can just put the string "Last Name" in the caption field to offer a more descriptive info about the field. This is a useful feature to enable database designer to stick with the naming convention of the database field names and on another hand does't compromise the descriptive level of each field.