FileMaker FM0-302 Exam Questions Free Practice Test

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Questions # 1:

Which two statements are true for an account in a FileMaker Pro 8 database that is authenticated externally? (Choose two.)

Options:

The database may be hosted on FileMaker Server 8.

The account is authenticated via : External Server.

The database may be hosted on FileMaker Pro 8 Advanced.

The account must be a member of a privilege set with the External Account extended privilege enabled.

Expert Solution

Questions # 2:

Which two privileges are needed for a non [Full Access] privilege set to allow the creation and modification of new layouts in a FileMaker Pro 8 database? (Choose two.)

Options:

Design layouts is checked in the Edit Account dialog.

[Any New Layout] layout privileges are set to modifiable.

Allow creation of new layouts is checked in the Edit Account dialog.

Allow creation of new layouts is checked in the Custom Layout Privileges dialog.

Expert Solution

Questions # 3:

Which three are required to get XML data, using a Web browser, from a database hosted by FileMaker Server 8 Advanced? (Choose three.)

Options:

a query string in an HTTP URL request

the FMPDSORESULT or fmresultset grammar

at least one account with the fmxml extended privilege assigned to its privilege set

XML Publishing enabled in the Web Publishing Administration Console

the Export Records [FMPDSORESULT] or Export Records [FMPXMLRESULT] script step included in a script set to run when the database opens

Expert Solution

Questions # 4:

Given a custom function created in FileMaker Pro 8 Advanced called "MyFunction" with a single parameter "Number" defined as:

If (

Number = 0 ;

Number ;

Number & ", " & MyFunction ( Number - 1 )

)

What is the result of MyFunction ( -3 )?

Options:

-3, -2, -1

-3, -2, -1, 0

Expert Solution

Questions # 5:

Which two statements are true about script parameters in FileMaker Pro 8? (Choose two.)

Options:

Script parameters can contain multiple delimited values.

A sub-script inherits the script parameter from the script that called it.

The Get(ScriptParameter) function returns the same result over the duration of a given script.

Script parameters for scripts that are set to run when a file opens are set from the File Menu > File Options dialog.

Expert Solution

Questions # 6:

Which three statements about field validation are true in FileMaker Pro 8? (Choose three.)

Options:

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.

Expert Solution

Questions # 7:

Click the Exhibit button

Consider a FileMaker Pro 8 database with two tables called Salesperson and Order, and a relationship between the two tables based on a SalespersonID field. The relationship is configured as shown in the exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a portal showing Order records via the above relationship.

Which three statements are true? (Choose three.)

Options:

Deleting a Salesperson record also deletes all related Order records.

It is possible to create new Salesperson records by importing data into the Order table.

It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in the context of the Order table occurrence.

Users may create new Order records by entering data into the portal on the Salesperson Detail layout.

It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a layout that is based on the Order table occurrence.

Expert Solution

Questions # 8:

A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)

Options:

importing data into that field

making a change to the field's data type

editing data in the field using Instant Web Publishing

clicking into the field, then immediately exiting the field

Expert Solution

Questions # 9:

What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?

Options:

64 kilobytes

2 gigabytes

8 terabytes

The number is limited only by disk space.

Expert Solution

Questions # 10:

A number field in FileMaker Pro 8 called AmountPaid is set to auto-enter the following formula:

Case (

AmountPaid > AmountDue;

TextColor (AmountPaid ; RGB (0; 255 ; 0));

AmountPaid > 0 ;

TextColor (AmountPaid ; RGB (255 ; 0 ; 0));

AmountPaid

)

The Do not replace existing value of field (if any) option is unchecked.

Which statement is true?

Options:

The calculation will only be evaluated the first time a value is entered into AmountPaid.

A user will not be able to manually edit the field once the calculation has been evaluated.

If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.

The calculation will prevent a user from entering an incorrect value into the AmountPaid field.

Expert Solution

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Pass the FileMaker Filemaker Certification FM0-302 Questions and answers with CertsForce