Black Friday Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Achieve Success in the FileMaker FM0-302 Exam: A Detailed FileMaker8 Developer Essentials Exam Guide

Questions 21

Given the following formula:

Date (

Month ( Get ( CurrentDate ) ) + 1;

1;

Year ( Get ( CurrentDate ) )

) - 1

What is the result?

Options:

A.

the last day of the next month

B.

the first day of the next month

C.

the last day of the current month

D.

the first day of the current month

Buy Now
Questions 22

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.

Buy Now
Questions 23

Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 24

The return delimited data in the Contact field of a FileMaker Pro 8 database are:

John Smith

Mary Jones

Julie Hyde

Which three formulas can be used to extract the string "Mary Jones" (without quotes) from Contact? (Choose three.)

Options:

A.

GetValue (Contact ; 2)

B.

Middle (Contact ; 12 ; 10)

C.

GetWords (Contact ; 3 ; 2)

D.

MiddleWords (Contact ; 3 ; 2)

E.

MiddleValues (Contact ; 2 ; 2)

Buy Now
Questions 25

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.

Buy Now
Questions 26

Which three are valid types listed in the FileMaker Pro 8 Export Records to File dialog? (Choose three.)

Options:

A.

XSL

B.

Merge

C.

HTML Table

D.

Microsoft Excel

E.

Microsoft Access

Buy Now
Questions 27

Which three text functions are case sensitive? (Choose three.)

Options:

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Buy Now
Questions 28

A Past Due script finds all customer records with past due invoices. Which script step needs to precede the Perform Find [ ] script step to ensure the script works properly?

Options:

A.

Go to Layout [ ]

B.

Select Window [ ]

C.

Set Selection [ ]

D.

Enter Browse Mode [ ]

Buy Now
Questions 29

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

Options:

A.

modifying cache size

B.

enabling secure connections

C.

enabling external authentication

D.

modifying an additional default database folder

Buy Now
Questions 30

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.

Buy Now
Exam Code: FM0-302
Exam Name: FileMaker8 Developer Essentials Exam
Last Update: Dec 12, 2024
Questions: 120

PDF + Testing Engine

$164.99
$66

Testing Engine

$124.99
$50

PDF (Q&A)

$104.99
$42

FileMaker Free Exams

FileMaker Free Exams
Enhance your FileMaker exam prep with free resources and practice tests from Examstrack. Achieve FileMaker certification success by exploring Examstrack.