Black Friday Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

 
Home > FileMaker > Filemaker Certification > FM0-302

FM0-302 FileMaker8 Developer Essentials Exam Question and Answers

Question # 4

Click the Exhibit button.

Given the FileMaker Pro 8 relationship graph shown in the exhibit, a layout assigned to the Teachers table occurrence has fields Name and Address, and a portal showing the Students table occurrence.

If a developer assigns the layout to the Advisors table occurrence, what happens to the data displayed?

A.

Name and Address do not display data and the portal shows all students of the current advisor.

B.

Name and Address show the current advisor and the portal shows all students of the current advisor.

C.

Name and Address show the first teacher of the first class of the first student of the current advisor and the portal shows all students of that teacher.

D.

Name and Address show the first teacher of the first class of the first student of the current advisor and the portal shows all students of the current advisor.

Full Access
Question # 5

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

A.

Copy [ ]

B.

Paste [ ]

C.

Set Field [ ]

D.

Set Selection [ ]

E.

Relookup Field Content [ ]

Full Access
Question # 6

Click the Exhibit button.

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

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

A.

The field displays .

B.

The field displays an enrolled student's name in each row of the portal.

C.

The field displays the first matching student's 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.

Full Access
Question # 7

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

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

Full Access
Question # 8

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

A.

?

B.

0

C.

-3, -2, -1

D.

-3, -2, -1, 0

Full Access
Question # 9

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

A.

create a "PDF Form" document

B.

dynamically name a PDF document

C.

attach a calculated password to control printing

D.

create a PDF based on a layout with a blank record

E.

create a directory into which to export a PDF document

Full Access
Question # 10

Which three statements are true about FileMaker Pro 8 Advanced? (Choose three.)

A.

FileMaker Pro 8 Advanced can import tables directly from a FileMaker Pro 7 file.

B.

FileMaker Pro 8 Advanced can import tables directly from a FileMaker Pro 6 file.

C.

FileMaker Pro 8 Advanced will retain internal IDs for fields when importing tables.

D.

FileMaker Pro 8 Advanced can copy/paste script steps, scripts, fields, and tables.

E.

FileMaker Pro 8 will import relationships for each of its Table occurrences when importing tables.

Full Access
Question # 11

What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)

A.

JDBC

B.

ODBC

C.

Excel files

D.

XML format

E.

HTML table format

Full Access
Question # 12

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

A.

a query string in an HTTP URL request

B.

the FMPDSORESULT or fmresultset grammar

C.

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

D.

XML Publishing enabled in the Web Publishing Administration Console

E.

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

Full Access
Question # 13

Click the Exhibit button.

You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may manage zero or more people. One person may be managed by at most one other person.

You want to build the system in such a way that a single layout showing information about a person can display both the name of the current person's manager (if any) and the names of all people managed by the current person.

What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?

A.

one

B.

two

C.

three

D.

four

Full Access
Question # 14

When importing one or more tables using the FileMaker Pro 8 Advanced Define Database dialog, which two statements are true? (Choose two.)

A.

Value lists from the selected tables are imported.

B.

Record data from the selected tables are not imported.

C.

Custom functions from the selected tables are imported.

D.

Relationships between multiple imported tables are preserved.

E.

All field definitions in the selected tables, including calculation and summary field definitions, are imported.

Full Access
Question # 15

Given the following formula:

Let ( myCalc = "6 * 3" ; Evaluate (myCalc))

Which value will be returned?

A.

0

B.

1

C.

18

D.

6 * 3

E.

myCalc

Full Access
Question # 16

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

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.

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

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

Full Access
Question # 18

Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)

A.

using a Privilege Set

B.

using a Calculation field

C.

changing the settings in the Field Format dialog

D.

changing the settings in the Field Behavior dialog

E.

disabling the Allow entry into field format option

Full Access
Copyright myexamcollection.com. All Right Reserved.