CertsTopics Logo

Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 60certs

FileMaker FM0-302 Dumps

Page: 1 / 5
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF

FileMaker8 Developer Essentials Exam Questions and Answers

Question 1

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:

A.

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

B.

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

C.

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

D.

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

Question 2

Which two statements are true of a FileMaker Pro 8 database? (Choose two.)

Options:

A.

Users can move and resize windows that are created through a script.

B.

Names of new windows created through the New Window script step must be unique.

C.

If a file has been configured to perform a script when closing the file, this script will always run when a window associated with that file is closed.

D.

It is possible to use a script to change the name of an existing window.

E.

There is no way to prevent a user from using the New Window menu command to create new windows.

Question 3

If x = 123.123, which three statements are true? (Choose three.)

Options:

A.

Int (x) = Floor (x)

B.

Int (x) = Ceiling (x)

C.

Int (x) = Round (x ; 0)

D.

Int (x) = Mod (x ; 0)

E.

Int (x) = Truncate (x ; 0)

F.

Int (x) = LeftValues (x ; 3)

Question 4

Which two can be used to import data into a FileMaker Pro 8 file directly from FileMaker Pro 6, without first having to export the data from FileMaker Pro 6? (Choose two.)

Options:

A.

XML

B.

SYLK

C.

HTML

D.

ODBC

Question 5

Given a FileMaker Pro 8 database with this script:

Perform Find [Restore]

#Find restores criteria: Customer::City: [XXXX]

Refresh Window

If [Get ( LastError )]

Show Custom Dialog ["No records found"; "No records matched your find criteria."]

End If

Which two statements are true if there are no records where the Customer::City field contains "XXXX"? (Choose two.)

Options:

A.

The user will see a default FileMaker error dialog stating that no records match this set of find requests.

B.

Adding a Set Error Capture [On] step to the beginning of the script will suppress the custom dialog.

C.

Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.

D.

Adding a Set Error Capture [On] step to the beginning of the script causes the FileMaker Pro 8 error dialog to display and then the custom dialog will display its error message.

Question 6

Given a table, Table A in File A; which permissions allow access to data in Table A from another file, File B?

Options:

A.

File B must be opened by an account with [Full Access].

B.

File A and File B must have an account with the same name and password.

C.

The privilege set associated with the account that is logged into File A must allow access to the records in Table A.

D.

The privilege set associated with the account that is logged into File B must allow access to the records in Table A.

Question 7

FileMaker Pro 8 allows five (5) failed login attempts before halting the re-login process. What are two ways this behavior can be altered? (Choose two.)

Options:

A.

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

B.

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

C.

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

D.

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

Question 8

Consider two files, Alpha and Beta, where tables from Beta are included in the Relationships Graph of Alpha as external table occurrences. What are two ways to rename Beta while preserving all functionality in Alpha? (Choose two.)

Options:

A.

change the file path of the Beta File Reference in Alpha

B.

rename Beta using the File > Save a Copy As... option

C.

rename any table occurrences that are based on Beta to match the new file name

D.

use Tools > Developer Utilities... in FileMaker Pro 8 Advanced to rename Beta

Question 9

When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)

Options:

A.

Secure connections are typically faster because of data encryption.

B.

Secure Sockets Layer (SSL) is used by FileMaker Pro 8 client connections.

C.

Connections between FileMaker Server 8 and FileMaker Pro 8 are encrypted.

D.

Connections between FileMaker Server 8 Advanced and XML clients are encrypted.

Question 10

A file has two layouts, Form and List. Form uses the [File Default] Menu Set. List uses a Custom Menu Set called List Menu.

The file default is set to [Standard FileMaker Menus]. The file has two scripts. Script A installs the Custom Menu Set List Menu. Script B installs the same Menu Set, but also includes the Use As File Default option.

If you are on the List layout, which statement is true?

Options:

A.

You run Script A, then switch to the Form layout and the List Menu Menu Set is active.

B.

You run Script B, then switch to the Form layout and the List Menu Menu Set is active.

C.

You run Script B, then switch to the Form layout and the [Standard FileMaker Menus]Menu Set is active.

D.

You switch to the Form layout, run Script A, then choose New Window and [Standard FileMaker Menus] is active.

Question 11

When manually importing data into a field that has a validation rule in FileMaker Pro 8, which statement is true?

Options:

A.

The validation cannot be triggered during the import.

B.

Unless the validation has been set to apply Always, data cannot be imported into the field.

C.

Assuming the validation has been set to apply Always, if one or more records fail the validation test, the import will abort at the first validation failure.

D.

Assuming the validation has been set to apply Always, if one or more records fail the validation test, a summary containing the number of validation failures will be presented at the end of the import.

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?

Options:

A.

0

B.

2

C.

4

D.

6

E.

8

Question 13

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:

A.

?

B.

0

C.

-3, -2, -1

D.

-3, -2, -1, 0

Question 14

Which two statements are true regarding the use of plug-ins? (Choose two.)

Options:

A.

Plug-ins provide additional script step capabilities.

B.

Plug-ins provide additional calculation capabilities.

C.

The Auto Update feature is implemented with a plug-in.

D.

Plug-ins can only be used on FileMaker Pro 8 and FileMaker Pro 8 Advanced.

Question 15

Click the Exhibit button.

You have a FileMaker Pro 8 layout based on the table occurrence Classes and you have a portal showing records from the table occurrence Students.

If you place the field Teachers::Name into the portal, the result is _____.

Options:

A.

The text is repeated in each row of the portal.

B.

The name of the teacher for the first enrollment record for this table.

C.

The name of the teacher for the class repeated in each row of the portal.

D.

The name of the teacher for the first related teacher value for each student enrolled.

Question 16

How would you configure a database so that users will not be prompted for a username and password when accessing the database via Instant Web Publishing?

Options:

A.

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

B.

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

C.

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

D.

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

Question 17

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

Options:

A.

importing data into that field

B.

making a change to the field's data type

C.

editing data in the field using Instant Web Publishing

D.

clicking into the field, then immediately exiting the field

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?

Options:

A.

only the current window's found set

B.

only the current window's found set and sort order

C.

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

D.

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

Page: 1 / 5
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF