FM0-302 FileMaker8 Developer Essentials Exam Questions and Answers

The ItemPrice field cannot be indexed since it references a related field.

A user cannot manually edit the contents of the ItemPrice field in Browse mode.

The value of the ItemPrice field will be looked up whenever a field in the current table is modified.

The value returned by ItemPrice will change whenever a product's price is changed in the Products table.

All four match fields must be indexed for the relationship to resolve properly.

When deleting a person record in the Person table, all tasks with that Person ID will be deleted.

The exhibit is invalid because it is not possible to create related records through a multi-predicate relationship.

When creating a related Task record via the relationship, both the Person ID and the Category ID in the task record will be populated.

Adjust Window [ ]

Enter Browse Mode [ ]

Enter Preview Mode [ ]

Enter Find Mode [Pause]

Move / Resize Window [ ]

Set Field [ ]

Select All [ ]

Go to Field [ ]

Open Record/Request [ ]

Leave the file's account settings in the default state.

Define a [Web] privilege set and a [Web]account with no password.

Enable the [Guest] account, and make it the only account with the [fmiwp] extended privilege enabled.

Set the Instant Web Publishing access to the file in the Instant Web Publishing dialog to All Users.

You can specify any layout in the current file as the destination layout.

You have the option to display the related records in any of the file's existing windows.

If there are no related records, the found set on the destination layout will not be altered in any way.

You have the option to show records related to the current record only or to all the records in the found set.

0

1

2

12

set the Allow User Abort [ ] script step to [on]

set the Set Error Capture [ ] script step to [on]

put the Re-Login [ ] script step in a loop that exits when Get(LastError) equals 0

define the maximum number of attempts in the Edit Privilege Set dialog

Fields can only be validated by a single criterion.

Field validation warnings may be triggered by scripts.

Users can be prevented from overriding the validation warning.

A script can be specified to run when manually entered field data fail validation.

Users can be presented with a specific message that they will see when a field fails validation.

which accounts are authenticated

minimum password length for associated accounts

whether or not the passwords of associated accounts expire

how many failed login attempts are allowed before associated accounts are disabled

Different windows in the same file can have a different menu set.

The ability to open a new window from the menu may not be removed by using a Custom Menu set.

A new window created using File Menu: Window > New Window will inherit the current active Menu set.

Closing all file windows without quitting the FileMaker Pro 8 application will keep the last active Custom Menu set until the application is quit.

You perform a script that includes Go to Field [ ] targeting one of the fields on the Phones tab.

You perform a script that includes Go to Tab [ ] targeting the Phones tab and one of the fields in the tab.

You use the Tab key until the Tab Control becomes active, then navigate to Phones using Arrow keys and press the Space bar. This works only if the Tab Control is included in the layout's Tab Order.

You use the Tab key until the Tab Control becomes active, then navigate to Phones using Arrow keys and press the Space bar. This works only if at least one field in the Phones tab is included in the layout's Tab Order.

It must be installed on the Web browser.

It must not attempt to display information to the user's screen.

It must be enabled for Web Publishing on FileMaker Server 8 Advanced.

It must be installed in the Plugins directory of the Web Publishing Engine.

Int (x) = Floor (x)

Int (x) = Ceiling (x)

Int (x) = Round (x ; 0)

Int (x) = Mod (x ; 0)

Int (x) = Truncate (x ; 0)

Int (x) = LeftValues (x ; 3)

Layouts in Alpha can display data from Beta.

Alpha can contain multiple valid file references to Beta.

It is impossible to lock records in both Alpha and Beta simultaneously.

Layouts from Beta cannot be displayed in the same window as layouts from Alpha.

A table occurrence from Beta is required on Alpha's Relationships Graph in order to call a script in Beta from Alpha.