FM0-305 Online Practice Questions and Answers

Which script trigger could provide the functionality to prevent invalid data from being committed while allowing the ability to revert the record?

A. OnObjectSave

B. OnObjectExit

C. OnObjectModify

D. OnObjectValidate

A layout contains a portal, based on a relationship configured to allow creation of related records.

The portal object has the name Portal_1. Which technique can be used to navigate to a field in the empty row at the end of Portal_1?

A. use the Set Selection script step targeting a field in Portal_1, followed by the script step Scroll Portal [Last]

B. use the Go To Field script step targeting a field in the desired portal, then use the Go To Portal Row [Last] script step

C. assuming a field in the desired portal is in the tab order, use the arrow keys to activate the portal, then tab to the desired row and field

D. use the Go To Portal[Portal_1] script step, followed by the Go To Portal Row [Last] script step and the Go To Field script step targeting the desired field

Which method can be used to sort related records within a portal in a FileMaker Pro 11 database?

A. In Layout Mode, rightclick on a field in the portal and choose Sort Portal from the contextual popup menu.

B. In Layout Mode, select the portal then choose Sort records in the Behavior section of the Data tab of the Inspector.

C. In the Relationships Graph, change the Sort records setting in the Specify Table dialog for the portal's table occurrence.

D. Run a script using the Sort Records [ ] script step, choosing the portal's table occurrence from the popup menu of the Sort related records checkbox option.

E. Change the Sort records setting in the Edit Relationship dialog for the last relationship leading to the portal's table occurrence from the context of the layout's table occurrence on the Relationships Graph.

Given the following formula in a calculation field that returns a Text result: Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) ) What will be returned?

A. the value 10

B. the value "10", quotes included

C. the value tmp

D. the value "tmp", quotes included

E. the value 2 * 5

F. the value "2 * 5", quotes included

Given a FileMaker Pro 11 database with the following script:

Perform Find [Restore]

# Find restores criteria: Customer::Name [Smith]

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::Name field contains "Smith"? (Choose two.)

A. Unless a Set Error Capture [On] step is added at the beginning of the script, Get (LastError) will not return an error value.

B. Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.

C. Adding a Set Error Capture [On] step to the beginning of the script will cause a default FileMaker error dialog to display, followed by the custom error dialog.

D. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.

A FileMaker Pro 11 database is hosted by FileMaker Server 11. User A and User B are accessing the database at the same time. User A runs a script that loops over a set of records and makes changes to those records. During the time that the script runs, User B is editing one of the records that is also in User A's found set and is being acted on by User A's script.

Which statement is true about this situation?

A. User A's script will stop looping when it reaches the record User B is editing.

B. User A's script will make changes to all records in its found set except the record being edited by User

B.

C. User A's script will stop looping when it reaches the record User B is editing, and will wait to continue until User B releases the record.

D. When it reaches the record User B is editing, User A's script will stop if User A's script is running with Set Error Capture[On]. Otherwise User A will be prompted to either continue or cancel the running script.

According to the FileMaker Server Configuration Guide, it is considered a best practice to use which two system settings on a FileMaker Server? (Choose two.)

A. enable File Vault

B. disable disk indexing

C. disable file and print sharing

D. install and enable virus protection software

E. set File and Printer Sharing for Microsoft Network Properties to "Maximize data throughput for file sharing"

Which two statements are true about the Administrator Groups feature in FileMaker Server 11? (Choose two.)

A. Administrator Groups provide an additional layer of database security.

B. A given database file may only be part of one Administrator Group at a time.

C. A user must have full access privileges in a file before being made a member of that file's Administrator Group.

D. Administrator Groups may be used to grant additional administrators the ability to open, close and back up specific sets of hosted databases.

When importing a folder of image files into FileMaker Pro records, which three pieces of information can be imported with each image? (Choose three.)

A. filename

B. file path

C. file size

D. image EXIF data

E. a smaller thumbnail image

Which three are necessary to create and publish a PHPbased Web site using the PHP Site Assistant? (Choose three.)

A. a copy of FileMaker Pro 11 Advanced

B. a working installation of FileMaker Server

C. a development computer with Java installed

D. a development computer with the PHP runtime engine installed

E. one or more hosted database files with the [fmphp] extended privilege enabled for at least one active user account