VA FileMan V. 22 Key and Index Tutorial
[Lesson 11 Quiz: Text Version]   [<-- Back to Lesson 11]

Lesson 11 - Quiz

Answer the questions by selecting the radio buttons, then click the Get Score button at the bottom of the page to calculate your score and see your test results.

1. The Mandatory/Required Field Check option checks that all fields that are key fields or designated as required:
Contain data.
Are unique.
Both of the above.
2. What FileMan option allows you to use a field's definition to verify the data stored in a file?
Verify Fields.
Modify File Attributes.
Neither of the above.
3. How has the FileMan option Enter or Edit File Entries been modified to automatically enforce key integrity?
FileMan does not let you delete key field values.
FileMan does not allow you to edit key field values.
Both of the above.
4. If you edit the key fields in a record, and FileMan encounters another record in the file that has the same key, a message is displayed indicating that making these edits would violate key integrity. In addition, FileMan automatically restores the key fields to their pre-edited values.
True.
False.
5. How do you instruct FileMan to fire the record-level indexes and check the integrity of all compound keys at a particular point in an input template or the DR input variable to ^DIE?
You can call the entry point FIRE^DIE.
You can set the variable DIEFIRE.
Both of the above.
6. If you set DIEFIRE to null ("") in an input template, record-level cross-references on edited fields would be fired at that point. If in addition, edits to key fields violate key integrity:
The key fields are restored to their pre-edited values.
X is set 'BADKEY'.
Both of the above.
7. In an input template, how would you instruct FileMan to fire record-level cross-references, and, if key integrity is violated, restore the key fields to their pre-edited values?
Set DIEFIRE to "R".
Set DIEFIRE to "M".
Both of the above.


[Lesson 11 Quiz: Text Version]   [<-- Back to Lesson 11]

 

Reviewed/Updated: March 20, 2007