While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:
Show All Records
Go to Record/Request/Page [First]
Loop
If [Customer::Category <> "A"}
Omit Record
Else
Go to Record/Request/Page [Next; Exit after last]
End If
Exit Loop If [Get ( FoundCount )= 0]]
End Loop
After the script stops running, which two statements are true? (Choose two.)
A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)
Which statement is true?
Which three script steps in a FileMaker Pro 8 database may fail if another user is editing the record on which the script is operating? (Choose three.)
Click the Exhibit button.
You run the following script from a layout assigned to the table occurrence Teachers:
Go to Related Record [Show only related records; From table: "Enrollment";
Using layout: "Enrollment" (Enrollment)]
Assuming there are matching records in all tables, what is the found set when the script completes?
Click the Exhibit button
Consider a FileMaker Pro 8 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.)
In a FileMaker Pro 8 database, which two functions can be used to return error codes for use in your formulas? (Choose two.)
A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)
