> Question 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?
A. At the file level in which the
fields are defined.
B. At a file level above the level in which
the fields are defined.
C. Neither of the above.
> Question 2: When
using the SORTING ONLY designation for an index, the index name must start with
a:
A. 'B' or a letter that alphabetically follows
'B'.
B. Sorting Only indexes must have names that start with the
letter 'A'.
C. Neither of the above.
> Question 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 However, if a
cross-reference value is not to be used as a subscript in the index, you must
remember to:
A. Delete the automatically generated subscript
number.
B. Use FileMan to turn off automatic generation of
subscript numbers.
C. Neither of the above.
> Question 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.
A. True
B. False
> Question 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.)
A. True
B. False
Question 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?
Answer: B. "At a
file level above the level in which the fields are defined."
Question 2: When using
the SORTING ONLY designation for an index, the index name must start with
a:
Answer: B. "Sorting
Only indexes must have names that start with the letter 'A'."
Question 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 However, if a cross-reference value is
not to be used as a subscript in the index, you must remember to:
Answer: A. "Delete
the automatically generated subscript number."
Question 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.
Answer: A. "True."
Question 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.)
Answer: A. "True."
Back to the top
Reviewed/Updated: March 20, 2007