FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. A FileMaker Pro 12 database is hosted by FileMaker Server 12. 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 As script.
Which statement is true about this situation?

A) User A's script will make changes to all records in its found set except the record being edited by User B
B) 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.
C) When it reaches the record User B is editing, User As 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.
D) User As script will stop looping when it reaches the record User B is editing.

2. Upon conversion from earlier versions of FileMaker Go to FileMaker Go 12, the conversion will make which two changes? (Choose two.)

A) A database without the fmrestorelogin extended privilege, will have the extended privilege fmreauthenticate0 created and assigned to each privilege set.
B) A database with the fmrestorelogin extended privilege will have this extended privilege removed.
C) A database without the fmrestorelogin extended privilege, will have the extended privilege fmreauthenticate(n) added, where the (n) will have the value specified from the Auto-Restore Login setting.
D) A database with the setting Auto-Restore Login will add the extended privilege fmreauthenticate(n), where n is obtained from fmrestorelogin.

3. Which three statements are true about installing and updating plug-ins in FileMaker Pro 12? (Choose three.)

A) A FileMaker plug-in can be inserted into a container field and installed on a client machine.
B) A plug-in must be stored on the server hosting the database to be automatically installed on client machines.
C) The fmpplugin extended privilege must be enabled to install a new plug-in.
D) The Allow Solutions to Install Files checkbox must be enabled in the Plug-Ins tab of Preferences.
E) A plug-in can be removed using a script that includes the Uninstall Plug-In File script step.
F) A plug-in can be automatically installed on a client machine by using OnFirstWindowOpen to trigger a script that tests for the presence of the plug-in with the Install Plug-In File script step.

4. Which two are required for a user to successfully run a script that uses the Execute SOL script step? (Choose two.)

A) A compatible ODBC driver on the computer executing the script
B) An ODBC Data Source in the Edit Data Source dialog for the file executing the script
C) The fmxdbc extended privilege assigned to the user's privilege set
D) An ODBC Data Source Name (DSN) on the computer executing the script

5. A text field called FirstLast in FileMaker Pro 12 is set to auto-enter the following formula: FirstName & " " & LastNarne
FirstName and LastNarne 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? (Choose two.)

A) any field value on the record is modified and the FirstLast field is empty
B) the FirstName or LastNarne field is modified and the FirstLast field is empty
C) each time the value of the FirstName or LastNarne field is modified
D) a user selects the menu item Records > Relookup Field Contents
E) a record is first created

Solutions: