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

Lesson 5 - 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. Whole-file indexes allow you to lookup records in a file or subfile based on field values within a subfile beneath that file or subfile. Where is a whole-file index stored?
At the file level in which the fields are defined.
At a file level above the level in which the fields are defined.
Neither of the above.
2. When using the SORTING ONLY designation for an index, the index name must start with a:
'B' or a letter that alphabetically follows 'B'.
Sorting Only indexes must have names that start with the letter 'A'.
Neither of the above.
3. In a Regular index, FileMan assumes that all fields you add as cross-reference values in the index will be used as subscripts and automatically assigns subscript numbers to them. Most of the time, this assumption is correct. However, if a cross-reference value is not to be used as a subscript in the index, you must remember to:
Delete the automatically generated subscript number.
Use FileMan to turn off automatic generation of subscript numbers.
Neither of the above.
4. To create a single subscript for an index based on two fields, first, create two cross-reference values (order numbers 1 and 2), one for each of the two fields. Second, delete the automatically generated subscript numbers. Third, create a computed cross-reference value (order number 3) designated as subscript 1.
True.
False.
5. New with VA FileMan Version 22.0, the advanced capabilities of Regular cross-references, which include the ability to define compound indexes, computed subscripts, and subscript transforms allow you to define as New-style Regular indexes. (Those indexes you previously had to define as MUMPS cross-references.)
True.
False.


[<-- Back to Lesson 5]   [Lesson 5 Quiz: Text Version]   [Go to Lesson 6 -->]

 


Reviewed/Updated: March 20, 2007