Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
FileMaker
Filemaker Certification
FM0-302
FileMaker8 Developer Essentials Exam Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam FM0-302 Premium Access

View all detail and faqs for the FM0-302 exam

Go to Exam

715 Students Passed

90% Average Score

90% Same Questions

Viewing page 2 out of 4 pages

Viewing questions 11-20 out of questions

Questions # 11:

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

Options:

Indexing improves the speed at which finds are performed.

Value lists require at least one referenced field to be indexed.

To establish a relationship between two fields, both fields are required to be indexed.

Using Unicode as the default language by which a field is indexed causes sorts on that field to be case sensitive.

A value index, used in establishing relationships, stores up to 60 primary characters or digits per return-delimited line.

Answer

A, B, D

Questions # 12:

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.

Answer

B, D

Questions # 13:

Click the Exhibit button.

What changes need to be made to the database to create a portal on a layout tied to the Customer table occurrence that displays all products (without duplication) that a customer has ever ordered?

Options:

No changes need to be made.

Create a calculation field in the OrderLineItem table that references the related product name.

Create a new relationship between the Customer table occurrence and the Product table occurrence.

Create a relationship between the Customer table occurrence and a second table occurrence of the Product table.

Answer

Questions # 14:

Which three are capabilities of the Save Records as PDF [ ] script step? (Choose three.)

Options:

create a "PDF Form" document

dynamically name a PDF document

attach a calculated password to control printing

create a PDF based on a layout with a blank record

create a directory into which to export a PDF document

Answer

B, C, D

Questions # 15:

Which three script steps in a FileMaker Pro 8 database may fail if another user is editing the record on which the script is operating? (Choose three.)

Options:

Copy [ ]

Paste [ ]

Set Field [ ]

Set Selection [ ]

Relookup Field Content [ ]

Answer

B, C, E

Questions # 16:

In FileMaker Pro 8 which two statements about portals are true? (Choose two.)

Options:

Container fields can be placed in portals.

The initial row setting of a portal can be set by a script.

A sort order applied to a portal overrides any sort order set up for the relationship.

If there are multiple portals on a layout, the Go to Portal Row [First] script step will activate the portal closest to the top, left corner of the layout.

Answer

A, C

Questions # 17:

Given the formula:

Filter ( "Computer Science 201"; "0123456789" )

What is the result?