Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)
Which three statements about field validation are true in FileMaker Pro 8? (Choose three.)
Which two statements are true of a FileMaker Pro 8 database? (Choose two.)
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.)
Consider a FileMaker Pro 8 database hosted by FileMaker Server 8. Two users, A and B, are accessing the database at the same time, and both are viewing records with the same layout. User A runs a script that loops through a found set, changing data in each record. Which statement is true?
When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)
On conversion to FileMaker Pro 8, what does the old password from FileMaker Pro 6 become?
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.)
What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?
The last script step in Script A in File A calls Script B in File B. Which three script steps can be used in Script B to make File B's front most window active without the need to use the Select Window [ ] script step? (Choose three.)
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 file has two layouts, Form and List. Form uses the [File Default] Menu Set. List uses a Custom Menu Set called List Menu.
The file default is set to [Standard FileMaker Menus]. The file has two scripts. Script A installs the Custom Menu Set List Menu. Script B installs the same Menu Set, but also includes the Use As File Default option.
If you are on the List layout, which statement is true?
A layout showing records from a People table has the Save record changes automatically checkbox disabled in the Layout Setup dialog. Which two actions cause FileMaker Pro 8 to display a dialog asking whether or not you want to save changes to the current record? (Choose two.)
Click the Exhibit button.
Given the FileMaker Pro 8 Relationships Graph shown in the exhibit, which table occurrence should be assigned to a layout that contains a portal that shows all students for all of a teacher's classes?
In FileMaker Pro 8 given a calculation field in the Items table named ItemPrice with the following formula:
Lookup (Products::Price)
Which statement is true?
Click the Exhibit button.
You want to build a FileMaker Pro 8 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.).
You want 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 you must define in the Tables tab of the Define Database dialog to construct the layout?
Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)
In the Fields tab of the Define Database dialog in FileMaker Pro 8, which two are valid field types? (Choose two.)