Choose two a the operator only works using numeric

Which two statements about relationships are true in FileMaker Pro 9? (Choose two.)
A. The > operator only works using numeric match fields.
B. It is possible to create a valid relationship where one match field isunindexed.
C. The relationship operator % (contains) allows the relationship definition to include Allow
creation of records in this table via this relationship.
D. The relationship operator X (cross product), allows the relationship definition to include Allow
creation of records in this table via this relationship.
E. The relationship operator <= (less than or equal) allows the relationship definition to include
Allow creation of records in this table via this relationship.
Answer: B,E
QUESTION NO: 72
A FileMaker Pro 9 database contains two tables:
Customers: customer_id, first_name, last_name
Invoices: invoice_ID, customer_ID and invoice_date
When looking at an invoice, a user also wants to view all other invoices for the same customer. To
create a portal that shows all invoices from the same customer as the current invoice, excluding
the current invoice, the user needs to create a relationship between which of the following?
A. Two occurrences of the Invoices table where
B. Two occurrences of the Invoices table where
invoice_id = invoice_id
C. Two occurrences of the Invoices table where
invoice_id ? invoice_id
D. Invoices and Customers where
Invoices::customer_id ? Customers::customer_id
Answer: C
26

QUESTION NO: 73
Exhibit: *missing*
FileMaker FM0-303 Exam
A user wants to build a FileMaker Pro 9 database that models family relationships. One person
may have many children. One person may also have many parents (including biological parents,
guardians, step-parents, etc.).
The user wants to build the system in such a way that a single layout showing information about a
person can also display two portals, one showing the names of all of the current person's children
(if any) and the other showing the names of all of the current person's parents (if known).
Assume that personal names exist in only one table. There are no lookup fields or calculation
fields in any tables, and there are no scripts in the file.
What is the minimum number of tables that must be defined in the Tables tab of the Manage
Database dialog to construct the layout?
A. 1
B. 2
C. 3
D. 5
Answer: B
QUESTION NO: 74
Exhibit: *Missing*
Consider a FileMaker Pro 9 database with two tables called Salesperson and Order, and a
relationship between the two tables based on a Salesperson ID 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 Salesperson records by importing data into the Order table.
C. Users may create new Order records by entering data into the portal on the Salesperson Detail
layout.