최신덤프를 제공합니다 ( 첫번째 시도에서 합격을 보증합니다 )

Ver:V2.15
Q&A:120 Q&As
업그레이트:2010-09-29

 

덤프문제보기:

 

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. 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
7. 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

8. 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
9. Click the Exhibit button.
You want to build a FileMaker Pro 7 database that models a business organizational chart. One person
may manage no one or many people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can
display both the name of the current person's manager (if any) and the names of all people managed by
the current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to
construct the layout?

A. one
B. two
C. three
D. four
Answer: A
10. Click the Exhibit button
Consider a FileMaker Pro 7 database with two tables called Salesperson and Order, and a relationship
between the two tables based on a SalespersonID field. The relationship is configured as shown in the

exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a
portal showing Order records via the above relationship.
Which three statements are true? (Choose three.)

A. Deleting a Salesperson record also deletes all related Order records.
B. It is possible to create new Order records by importing data into the Salesperson table.
C. It is possible to create new Salesperson records by importing data into the Order table.
D. Users may create new Order records by entering data into the portal on the Salesperson Detail layout
E. It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in
the context of the Order table.
F. It is possible to create a new Salesperson record by typing into a related salesperson field displayed on

a layout that is based on the Order table.
Answer: DEF
11. Which three statements about field validation are true in FileMaker Pro 7? (Choose three.)
A. Fields can only be validated by a single criterion.
B. Field validation warnings may be triggered by scripts.
C. Users can be prevented from overriding the validation warning.
D. Users can be presented with a specific message that will see when a field fails validation.
E. A script can be specified to run when manually entered field data fails validation.
Answer: BCD