Pass the FileMaker Filemaker Certification FM0-302 Questions and answers with ExamsMirror

Given the following formula:

Date (

Month ( Get ( CurrentDate ) ) + 1;

1;

Year ( Get ( CurrentDate ) )

) - 1

What is the result?

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.)

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?

A layout contains a portal that allows creation of related records. What are two techniques that can be used to navigate to the empty row at the bottom of the portal? (Choose two.)

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.)