FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. Which statement is true of container fields in FileMaker Pro 12?

A) A container must be optimized for Interactive content using the Inspector in Layout mode to allow drag and drop insertion of files into the container.
B) A container optimized for Interactive content using the Inspector in Layout mode will render HTML files as web pages in Browse mode.
C) OLE objects can be inserted into container fields if the field is set for Interactive content using the Inspector in Layout mode.
D) A user can insert a file using Store only a reference to the file if the container is set to Store container data externally
E) Files stored (not referenced) in containers fields defined to Store container data externally can be opened by a double-click in Browse mode.

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

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

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

A) in Layout Mode, select the portal then choose Sort records in the Behavior section of the Data tab of the Inspector
B) run a script using the Sort Records by Field script step, choosing one of the portal's related fields and checking the Sort only related records option
C) in Browse Mode, right-click on a field in the portal and choose Sort Ascending from the contextual pop-up menu
D) in the Relationships Graph, change the Sort records setting in the Specify Table dialog for the portal's table occurrence
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

4. A FileMaker Pro 12 file contains the following script:

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) 7
C) No value will be returned.
D) 6

5. Which three features of native FileMaker Pro 12 tables do NOT function correctly for data tables from an external ODBC data source (ESS)? (Choose three.)

A) Relationships using the >, <, or operator
B) Value lists
C) Storage of rich text (bold face, colored text, etc.)
D) Binary storage of picture and movie files
E) Auto-Complete using existing values as a setting under the Data tab in the Inspector
F) Relationships containing multiple match criteria

Solutions: