The return delimited data in the Contact field of a FileMaker Pro 8 database are:
John Smith
Mary Jones
Julie Hyde
Which three formulas can be used to extract the string "Mary Jones" (without quotes) from Contact? (Choose three.)
A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
Given the following function:
Let ([ name = "William Henry Smith" ;
len = Length (name) ;
lastSpace = Position (name ; " " ; len ; -1)] ;
Right (name ; len - lastSpace)
)
Which value will be returned?
Click the Exhibit button.
Your database has four tables: Customer, Invoice, Line Item, and Product. The relationships are displayed in the Relationships Graph exhibit.
Your users want to select a group of customers and then view all unique products purchased by those customers.
Which two techniques successfully accomplish this without changing the Relationships Graph? (Choose two.)
Which setting change requires FileMaker Server 8 or FileMaker Server 8 Advanced to be restarted to take effect?
How would you configure a database so that users will not be prompted for a username and password when accessing the database via Instant Web Publishing?
Which two are required for a plug-in to be used with Web Published databases? (Choose two.)
Given a FileMaker Pro 8 database containing these two scripts::
Script A:
Perform Script ["Script B" ; Parameter: 3]
Show Custom Dialog [Get (ScriptResult)]
Script B:
Set Variable [$x; Value:Get (ScriptParameter)]
Loop
Set Variable [$result ; Value: $result + $x]
Set Variable [$x ; Value: $x - 1]
Exit Loop If [$x = 0]
End Loop
Exit Script [Result: $result]
If a user runs Script A, what value will be displayed in the custom dialog?
What are two reasons you might use the Let function within a calculation formula in a FileMaker Pro 8 database field? (Choose two.)
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.)
TESTED 23 Feb 2025
