FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. The following script is run from a record on a layout based on a table occurrence that is not related to the Product table occurrence:
Go to Related Record [Show only related records; Match found set; From table: "Product"; Using layout: "Product" (Product)] Delete All Records [No dialog]
What happens after the script is run?

A) All records in the Product table are deleted.
B) All records in the current table are deleted.
C) All records in the current found set for the Product table are deleted.
D) All records in the current found set are deleted.

2. Which two statements are true about setting up a System-level script to run as a scheduled script in FileMaker Server 12? (Choose two.)

A) In Windows, either the Local System account or a user account can be used. The account can be a local account on the master machine or a network domain account.
B) The System-level script must reside in the Scripts subdirectory of FileMaker Server 12.
C) In Mac OS X, either the fmserver user account or a user account can be used. The account can be a local account on the master machine or a network domain account.
D) By default the script will run as the user name specified for Admin Console account under General Settings.

3. A developer creates a database with the following Custom Menu settings installed as the file default:
Custom Menu settings: The New Record command has an override title of New Order The Delete Record command has an override title of Delete Order The Save/Send Records As > PDF command has an override title of Order Report
Assume buttons for these are on the Status Toolbar. The file is hosted and subsequently opened by a user with a privilege set which prohibits deletion of records.
Which statement is true about this situation?

A) Buttons named New Record, Delete Record, and Save as PDF are visible, but the Delete Record button is grayed out.
B) A button named New Order is visible and available, a button named Delete Order is visible but grayed out.
C) Buttons named New Order, Delete Order, and Order Report are visible and appear available, but the Delete Report button generates an alert when it is clicked.
D) Buttons named New Record and Delete Record are visible, but the Delete Record button is grayed out.

4. For server-hosted databases, FileMaker Server 12 Advanced is required for which three operations? (Choose three.)

A) Accessing External SQL data sources
B) Acting as an ODBC data source
C) Importing ODBC data
D) Sharing via Instant Web Publishing
E) Sharing via Custom Web Publishing
F) Sharing to more than 250 simultaneous FileMaker Pro 12 users

5. Given a text field Full Name, Auto-Enter by Calculated value has been selected in the field options, using the following formula:
Name First &." "& Name Last
The developer then disables (unchecks) the option Do not replace existing value of field (if any).
For which two cases will the results of the specified formula be inserted into the field Full Name? (Choose two.)

A) When the field Full Name itself is modified and the record is committed
B) When either of the fields Name First or Name Last is modified
C) Only when the field Full Name was previously empty
D) When the field Full Name itself is modified
E) When the record is first created

Solutions: