FileMaker Developer Essentials for FileMaker 12 - FM0-307 Free Exam Questions

A. Each privilege set must be associated with at least one account.

B. The default privilege sets in a new database can be set to Inactive.

C. An account can be associated with only one privilege set.

D. There can be multiple accounts associated with the [Full Access] privilege set.

A. The text <Field Missing> is displayed in each row of the portal.

B. Each row shows the name of each enrolled employee's first related trainer.

C. The name of the trainer for the first class enrolled by the first Employee record of the portal is repeated in each row of the portal.

D. The name of the first related trainer for the class is repeated in each row of the portal.

A. Concatenate multiple number fields from the current record into a return-delimited list

B. Specify a summary field from a related set of records as the data series and put the chart in a Subsummary layout part

C. Set up multiple data series, each of which points to a number field in the current record

D. Specify a summary field from the current found set as the data series and put the chart in a Leading Grand Summary layout part

A. The value of $$currentTransactionCount will be initialized to a null value each time the user opens the file.

B. $$curtentTransactionCount does not exist when the file is opened.

C. Whenever a user runs a script that updates the value of $$currentTransactionCount, all other logged-in users will see the changed value.

D. When a user logs into the file, the value in $$currentTransactionCount will be the value the variable had when the user last logged out.

E. If the value of $$currentTransactionCount is changed by a server-side script, all logged-in users will see the new value.

A. Validation: unique value

B. Validation: existing value

C. Auto-enter: serial number, on commit

D. Storage: Minimal Indexing

E. Auto-enter: creation date

F. Validation: validated by calculation

A. 6

B. 3

C. 4

D. 5

A. A Touch theme (e.g. River Touch) must be used for a layout to be compatible with iOS devices.

B. Changing a layout's theme will optionally update all layouts sharing the same original theme by choosing Update matching layouts in the Change Theme dialog.

C. The style attributes for a new object (e.g. field or text box) added to a layout will be determined by the layout part in which it is created

D. Holding down the Control (Windows) or Command (Mac OS X) keys while clicking the Apply theme styles button of the Inspector, the object styles of the currently selected object will be applied to all objects of the same type on the layout.

E. Changing a layout to the Classic theme of the Basic theme group will leave all objects and their styles unaffected.

A. A container optimized for Interactive content using the Inspector in Layout mode will render HTML files as web pages in Browse mode.

B. A user can insert a file using Store only a reference to the file if the container is set to Store container data externally

C. Files stored (not referenced) in containers fields defined to Store container data externally can be opened by a double-click in Browse mode.

D. 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.

E. OLE objects can be inserted into container fields if the field is set for Interactive content using the Inspector in Layout mode.

A. fmxdbc

B. fmxml

C. fmiwp

D. fmreauthenticate (n)

E. fmapp

F. fmios

G. fmphp

A. Finance is set as the Primary Account in the external directory server.

B. Finance is before Sales when the accounts are viewed in authentication order.

C. The Sales account has been made inactive in the Manage Security dialog.

D. The Sales and Finance accounts have different passwords.

A. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task and Volunteer data.

B. The Event table occurrence references a table from an external ODBC Data Source

C. There can be zero or one, but no more than one, Event record related to any Task record.

D. The corner arrows indicate all three table occurrences reference tables from external data sources.

A. File4

B. File1 and FilE3

C. File2 and File4

D. File3andFile4

E. File2, File3, and File4

A. Externally stored container data can be stored on a local hard drive or a Storage Area Network (SAN) device, but cannot be stored on a Network Attached Storage (NAS) device.

B. Externally stored container data will not be backed up by FileMaker Server 12 scheduled backup routines.

C. The field cannot have the Interactive content option selected in the Inspector in Layout mode.

D. Data will not be stored externally if the file is transferred to an iOS device and used via FileMaker Go 12.

A. bases the portal on the multi-predicate relationship: Players::TeamID = Teammates::TeamID AND Players: PlayerID Teammates:: PlayerID

B. base the portal on the relationship Players:: Team ID = Teammates:: Team ID And use a portal filter based on the calculation Players:: PlayerID Self

C. base the portal on the relationship Players:: TeamID = Teammates:: TeamID And use a portal filter based on the calculation Players:: PlayerID Teammates:: PlayerID

D. base the portal on the relationship Players::TeamID = Teammates::TeamID Set a sort order of PlayerID. Ascending on the relationship, and Configure the portal to have an Initial row value of 2.

A. The List function

B. The ExecuteSQL calculation function with a JOIN in the query

C. Auto-complete using existing values

D. Dynamic value lists based on FileMaker tables

E. Dynamic subsummary reports in Browse mode