Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

FM0-302 FileMaker8 Developer Essentials Exam Free Practice Exam Questions (2025 Updated)

Prepare effectively for your FileMaker FM0-302 FileMaker8 Developer Essentials Exam certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

FileMaker FM0-302 Premium Access     Download Demo    
Page: 2 / 2
Total 120 questions

A layout contains a portal that allows creation of related records. What are two techniques that can be used to navigate to the empty row at the bottom of the portal? (Choose two.)

A.

use the script step Go to Portal Row [Select; Last]

B.

use the script step Go to NthRecord [fieldName; Last]

C.

assuming a field in the portal is in the tab order, click or tab to the first portal row then arrow down to the last row

D.

assuming a field in the portal is in the tab order, click or tab to the first portal row and continue to tab to the last row

In FileMaker Pro 8, what are three things you can do using the script steps for managing accounts? (Choose three.)

A.

Create a privilege set.

B.

Add and delete accounts.

C.

Reset account passwords.

D.

Log in to a file with a different account and password.

E.

Assign a different privilege set to an existing account.

When importing table schema and data using FileMaker Pro 8 Advanced, which two statements are true? (Choose two.)

A.

Privileges from the source file are retained.

B.

Tables can be imported directly from FileMaker Pro 6 files.

C.

Relationships between table occurrences are not retained.

D.

You must have [Full Access] privileges to both the source and destination files.

Click the Exhibit button.

Given the relationship shown in the exhibit, which statement is true?

A.

All four match fields must be indexed for the relationship to resolve properly.

B.

When deleting a person record in the Person table, all tasks with that Person ID will be deleted.

C.

The exhibit is invalid because it is not possible to create related records through a multi-predicate relationship.

D.

When creating a related Task record via the relationship, both the Person ID and the Category ID in the task record will be populated.

Given the following formula:

Date (

Month ( Get ( CurrentDate ) ) + 1;

1;

Year ( Get ( CurrentDate ) )

) - 1

What is the result?

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

In FileMaker Pro 8 given a calculation field in the Items table named ItemPrice with the following formula:

Lookup (Products::Price)

Which statement is true?

A.

The ItemPrice field cannot be indexed since it references a related field.

B.

A user cannot manually edit the contents of the ItemPrice field in Browse mode.

C.

The value of the ItemPrice field will be looked up whenever a field in the current table is modified.

D.

The value returned by ItemPrice will change whenever a product's price is changed in the Products table.

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?

A.

the account with the least restrictive access permissions

B.

the account with the most restrictive access permissions

C.

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

D.

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

Click the Exhibit button.

Your database has four tables: Customer, Invoice, Line Item, and Product. The relationships are displayed in the Relationships Graph exhibit.

Your users want to select a group of customers and then view all unique products purchased by those customers.

Which two techniques successfully accomplish this without changing the Relationships Graph? (Choose two.)

A.

You build a portal on a Customer layout that shows related Product records.

B.

You write a script that uses a Go To Related Records [ ] script step to navigate from a Customer layout to the desired set of Product records.

C.

You create a button on a special Customer layout that performs a Copy All Records/Requests[ ] script step and allows users to paste the result into a Find request.

D.

You loop through the found set of Customer records, assembling a set of ID values into a global variable. You then loop again on a Products layout, creating single find requests for each ID value.

Click the Exhibit button.

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

What happens if you place the field Classes::Class Name into the portal?

A.

The field displays .

B.

The field displays the class name of the first related student.

C.

The field displays the teacher's first class name in every portal row.

D.

The field displays an enrolled student's name in each row of the portal only if the student name is calculated in the Enrollment table.

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

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

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

A.

modifying cache size

B.

enabling secure connections

C.

enabling external authentication

D.

modifying an additional default database folder

The components of FileMaker Server 8 Advanced may be installed on _____.

A.

one server only

B.

two servers only

C.

three servers only

D.

one or two servers only

E.

one, two, or three servers

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.)

A.

GetValue (Contact ; 2)

B.

Middle (Contact ; 12 ; 10)

C.

GetWords (Contact ; 3 ; 2)

D.

MiddleWords (Contact ; 3 ; 2)

E.

MiddleValues (Contact ; 2 ; 2)

For FileMaker Pro 8 files that are opened (i.e. to resolve a relationship) and where the window remains hidden, which statement is true about a script set to perform When opening this file?

A.

It will not execute.

B.

It will execute as soon as the file is opened.

C.

It will execute as soon as the first window is drawn.

D.

It will execute when the file is opened only if the script has the run script with full access privileges option enabled.

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

A.

to declare a variable that will be used within the formula

B.

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

C.

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

D.

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

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?

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.

FileMaker FM0-302 Premium Access     Download Demo    
Page: 2 / 2
Total 120 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved