Question 3
You receive the following memo:
We need a new field to store skills. At the present time, we have identified five skills; however, this will likely increase in the future. Each skill will have a three-character code and a description. We want the skill to be searchable by the description.
How would you create this field?
Create a three-character field for SKILL and add translate values for the initial five skills defined. When you add the field to the record, set it up as an alternate search key and translate table edit
Create a three-character field for SKILL and then create a Skills table with two fields: SKILL and DESCR. When you add the field to the record, set it up as a prompt table edit referencing the Skills table
Create a three-character field for SKILL and then create a Skills table with two fields: SKILL and DESCR. When you add the field to the record, set it up as an alternate search key and prompt table edit referencing the Skills table
Create a three-character field for SKILL and add translate values for the initial five skills defined. When you add the field to the record, set it up as a translate table edit
Correct answer: D