FM0-302 Practice Exam Questions with Answers FileMaker8 Developer Essentials Exam Certification

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

What is the result of the following formula?

Substitute("Abcd"; ["a";"b"];["b";"a"];["c";"d"];["d";"c"])

What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)

Given a FileMaker Pro 8 database with this script:

Perform Find [Restore]

#Find restores criteria: Customer::City: [XXXX]

Refresh Window

If [Get ( LastError )]

Show Custom Dialog ["No records found"; "No records matched your find criteria."]

End If

Which two statements are true if there are no records where the Customer::City field contains "XXXX"? (Choose two.)

Which three occur if the hard disk runs out of space during a "live" backup of files hosted on FileMaker Server 8? (Choose three.)

Which setting change requires FileMaker Server 8 or FileMaker Server 8 Advanced to be restarted to take effect?

Given the formula:

Choose( Qty / 100; 0; 2; 4; 6; 8 )

If the field Qty contains the value 250, what is the result?

Click the Exhibit button.

Given the relationship shown in the exhibit, which statement is true?

A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)

When importing table schema and data using FileMaker Pro 8 Advanced, which two statements are true? (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.)

Click the Exhibit button.

You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may manage zero or more people. One person may be managed by at most one other person.

You want to build the system in such a way that a single layout showing information about a person can display both the name of the current person's manager (if any) and the names of all people managed by the current person.

What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?

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