FM0-302 Exam Dumps - FileMaker8 Developer Essentials Exam

Question # 4

Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)

Copy to a remote hard drive.

Use the Save a Copy As command.

Use an OS script to pause and copy files.

Trigger a "Live" backup from a command line.

Use a "Live" backup scheduled in the FileMaker Server 8 Task Scheduling assistant.

Full Access

Question # 5

Which two statements regarding the Go to Related Records [ ]script step are true? (Choose two.)

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.

Full Access

Question # 6

On conversion to FileMaker Pro 8, what does the old password from FileMaker Pro 6 become?

a privilege set

only the account name

only the account password

both an account name and account password

Full Access

Question # 7

Click the Task button.

Place each specification next to its definition for FileMaker Server 8 Advanced (Windows OS).

Full Access

Question # 8

Which setting change requires FileMaker Server 8 or FileMaker Server 8 Advanced to be restarted to take effect?

modifying cache size

enabling secure connections

enabling external authentication

modifying an additional default database folder

Full Access

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.

The modifiedBy field will contain a complete history of everyone who has modified the current record.

The Quote function is used so that the quotation marks around "Modifiedby: " will be escaped properly.

Full Access

Question # 17

What are two reasons you might use the Let function within a calculation formula in a FileMaker Pro 8 database field? (Choose two.)

to declare a variable that will be used within the formula

to set a variable that can be used elsewhere within a script

to modify data in a text field referenced elsewhere in the formula

to create a custom function that can be used in other calculation formulas

Full Access

Question # 18

A FileMaker Pro 8 database has three separate windows open, each with its own found set and sort order. If a new window is opened, what will the new window inherit from the previously active window?

only the current window's found set

only the current window's found set and sort order

only the current window's found set, sort order, and layout

the current window's found set, sort order, layout, and current record

Full Access