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

What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 11 Advanced?

A. 10,000

B. 32,000

C. 50,000

D. 64,000

A Text field called FirstLast in FileMaker Pro 11 is set to autoenterb the following formula:

FirstName and LastName.

FirstName and LastName are Text fields in the same table. The option Do not evaluate if all referenced fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked. Under which two circumstances will the value of the calculation be inserted into the FirstLast field? (Chooseb two.)

A. a record is first created

B. a user selects the menu item Records > Relookup Field Contents

C. each time the value of the FirstName or LastName field is modified

D. any field value on the record is modified and the FirstLast field is empty

E. the FirstName or LastName field is modified and the FirstLast field is empty

Given the following Relationships Graph for a FileMaker 11 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

Assuming the relevant fields also exist in these tables, which two sets of data can be shown in portals without modifying the graph? (Choose two.)

A. a portal of trainers that have taught their own manager

B. a portal of students that have not enrolled in a class

C. a portal showing a nonrepeating list of courseware titles taught by a trainer

D. a portal of the classes that have been attended by a trainer's direct reports

E. a portal of classes in which a manager enrolled with one or more of the manager's direct reports

Given the following function: Position ( "Bobby Bubbles" "B" 2 2 ) What is returned?

A. 0

B. 3

C. 4

D. 7

A FileMaker Pro 11 file contains the following script:

Set Variable [$counter Value:1]

Go To Record/Request/Page [First]

Loop

Go To Record/Request/Page [Next]

Exit Loop If [$counter > Get(RecordNumber)]

Set Variable [$counter Value: $counter + 1]

End Loop

#

Exit Script [Result: $counter]

If this script is executed in a context where there is found a set of six records, which value will be returned

from the script?

A. 1

B. 6

C. 7

D. 8

E. No value will be returned.

Given Table A in File A, which condition allows access to Table A while using another file called File B?

A. File B must be opened and cascade its account credentials to File A.

B. File A and File B must have an account with the same name and password.

C. The privilege set associated with the account that is logged into File A must allow access to the records in Table A.

D. The privilege set associated with the account that is logged into File B must allow access to the records in Table A.

Which two will allow an account to perform a serverside script in FileMaker Server 11? (Choose two.)

A. The specified script is set to Run with Full Access.

B. The Extended Privilege Access via Server Scripts [fmsscript] is checked.

C. The Extended Privilege Access via FileMaker Network [fmapp] is checked.

D. The Allow Enabled Schedules to Run is checked in the FileMaker Server Admin Console.

E. The account under which the script is run must have privileges to execute the specified script.

Which three are valid types listed in the FileMaker Pro 11 Export Records to File dialog? (Choose three.)

A. PDF

B. XML

C. XSL

D. DBF

E. HTML Table

F. Access (.mdb)

How should a database be configured so that users will NOT be prompted for a user name and password when accessing the database via Instant Web Publishing (IWP)?

A. replace the default IWP login page with a custom home page

B. enable the [Guest] account and ensure that it is the only active account with the [fmiwp] extended privilege enabled

C. ensure that at least one user account has the [fmiwp] extended privilege and that the password for the account is blank

D. create a script that uses the Relogin script step to log all users in as the [Guest] user, and set that script to run when the file opens