FM0-302 Exam Dumps - FileMaker8 Developer Essentials Exam

Go to page:

Question # 9

A user attempts to log in to a database hosted on FileMaker Server 8. It is set up to allow authentication via FileMaker and External Server accounts. The user is a member of two external groups that have been set up in the Edit Account dialog to be authenticated using an external server. Assuming a valid username and password, with which matching account will the user authenticate?

the account with the least restrictive access permissions

the account with the most restrictive access permissions

the first account created in the Accounts tab of the Define Accounts & Privileges dialog

the first account listed in the Accounts tab of the Define Accounts & Privileges dialog when viewed by authentication order

Full Access

Question # 10

Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)

using a Privilege Set

using a Calculation field

changing the settings in the Field Format dialog

changing the settings in the Field Behavior dialog

disabling the Allow entry into field format option

Full Access

Question # 11

In FileMaker Pro 8, which two can reference unrelated table occurrences? (Choose two.)

find requests

global variables

globally stored fields placed on layouts

globally stored fields placed on portal rows

Full Access

Question # 12

Given the formula:

Choose( Qty / 100; 0; 2; 4; 6; 8 )

If the field Qty contains the value 250, what is the result?

Full Access

Question # 13

Which two statements are true about the [Guest] account that is included by default when creating a new FileMaker Pro 8 database? (Choose two.)

It is not enabled.

It cannot be deleted.

It can log in without entering a password.

It can log in using Instant Web Publishing without entering either a username or password.

Full Access

Question # 14

Which three Web Publishing options are available in FileMaker 8? (Choose three.)

Instant Web Publishing using FileMaker Pro 8

Instant Web Publishing using FileMaker Server 8

Custom Web Publishing using FileMaker Pro 8 Advanced

Instant Web Publishing using FileMaker Server 8 Advanced

Custom Web Publishing using FileMaker Server 8 Advanced

Full Access

Question # 15

Consider a FileMaker Pro 8 database with the following tables and fields:

Customer: customer_id, first_name, last_name

Order: order_id, customer_id, order_date

Product_Orders: order_id, product_id, quantity_ordered

Product: product_id, product_name, unit_price

Using only Cartesian cross-product ("x") relationships between table occurrences, sorting if necessary, which two actions can be performed? (Choose two.)

determine the date of the most recent order

display all records from the Customer table in a portal

create a value list that shows all orders for a chosen customer

create a portal to show one record for each product that has ever been ordered

Full Access

Question # 16

Given a stored calculation field modifiedBy that contains the following formula:

Evaluate ( Quote ("Modifiedby: " & Get (AccountName)) ; myField)

Which two statements are true? (Choose two.)

The modifiedBy field will only be updated when the value of myField changes.

The value of myField will be set to the results returned by the modifiedBy field.

The modifiedBy field will be updated whenever a field other than myField is changed.