Cisco CCNA CCNP CCSP exams

　
　
Exam : FileMaker FM0-301
Title : Filemaker7 Developer Essentials Exam

1. Which two statements about relationships are true in FileMaker Pro 7? (Choose two.)
A. The > operator only works using numeric match fields.
B. You can build a relationship using multiple match fields.
C. It is possible to create a valid relationship where one match field is unindexed.
D. A table occurrence must be connected to at least one other table occurrence.
E. When enabling the option, "Allow creation of records in this table via this relationship", only =, >=, <= will properly populate match keys.
Answer: BC

2. Consider a FileMaker Pro 7 database with the following tables and fields:
Using only Cartesian (cross or x ) relationships between occurrences of these tables, sorting if necessary, which two actions can be performed? (Choose two.)
A. determine the mode of the order amount
B. determine the date of the most recent order
C. display all records from the Customer table in a portal
D. create a value list that shows all orders for a chosen customer
E. create a portal to show one record for each product that has ever been ordered
Answer: BC

3. Which three statements are true about field indexing in FileMaker Pro 7? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one of any field they reference to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A value index, used in establishing relationships, stores up to 60 primary characters or digits per return-delimited line.
E. Using Unicode or ASCII as the default language by which a field is indexed causes sorts on that field to be case sensitive.
Answer: ABE

4. If a field in FileMaker Pro 7 has been set to validate Always, which three actions will trigger validation on that field? (Choose three.)
A. importing data into that field
B. exporting data from that field
C. editing data in the field using Instant Web Publishing
D. clicking into the field, then immediately exiting the field
E. attempting to change the value of the field using a Set Field[ ] script step
Answer: ACE

5. A database has two tables, Planet and Moon. Moons are related to a single planet and their relationship is set to delete related records in the Moon table when a Planet record is deleted. Which two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog? (Choose two.)
A. All data in the Planet table are deleted.
B. All records in the Moon table are deleted.
C. All records in the Moon table remain unaffected.
D. All records in the Moon table are deleted if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.
E. All table occurrences of both Planet and Moon tables are removed if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.
Answer: AC

6. What is the maximum number of files that can be hosted on FileMaker Server 7?
A. 125
B. 250
C. 350
D. 500
E. The number is limited only by server hardware.
Answer: A

7. What is the maximum number of characters that can be entered or imported into a text field in FileMaker Pro 7?
A. 64 thousand
B. 1 million
C. 1 billion
D. 1 trillion
E. Number of characters is limited only by disk space.
Answer: C

8. A number field in FileMaker Pro 7 called AmountPaid is set to auto-enter the following formula:.
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
A. The calculation will only be evaluated the first time a value is entered into AmountPaid .
B. A user will not be able to manually edit the field once the calculation has been evaluated.
C. If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.
D. The calculation will prevent a user from entering an incorrect value into the AmoundPaid field.
Answer: C

Free 640-802 Demo Download

Free demo for FileMaker FileMaker Certification FM0-301 exam (Filemaker7 Developer Essentials Exam). You can check out the interface, question quality and usability of our practice exams

Free Download 640-802 Exam Pdf Demo
Free Download 640-802 Exam iEngine Demo