Which two statements are true regarding the use of plug-ins? (Choose two.)
Given a custom function created in FileMaker Pro 8 Advanced called "MyFunction" with a single parameter "Number" defined as:
If (
Number = 0 ;
Number ;
Number & ", " & MyFunction ( Number - 1 )
)
What is the result of MyFunction ( -3 )?
Given the following formula:
Let ( myCalc = "6 * 3" ; Evaluate (myCalc))
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.)
What are two reasons you might use the Let function within a calculation formula in a FileMaker Pro 8 database field? (Choose two.)
A Past Due script finds all customer records with past due invoices. Which script step needs to precede the Perform Find [ ] script step to ensure the script works properly?
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.)
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?
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.)
Given the following formula:
Date (
Month ( Get ( CurrentDate ) ) + 1;
1;
Year ( Get ( CurrentDate ) )
) - 1
What is the result?
