New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. FileMaker
  3. Filemaker Certification
  4. FM0-302 - FileMaker8 Developer Essentials Exam

FileMaker FM0-302 FileMaker8 Developer Essentials Exam Exam Practice Test

Demo: 18 questions
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF

FileMaker8 Developer Essentials Exam Questions and Answers

Question 1

You are using FileMaker Pro 8 Advanced and planning a Contacts database. Others will be able to modify field definitions after you finish the creation of the database. You are considering using a custom function available on a public website to help in formatting phone numbers. What are three reasons to use custom functions in this situation? (Choose three.)

Options:

A.

to hide a proprietary formula

B.

to ease multiple file development

C.

to simplify use of the formula by any user

D.

to improve formatting consistency throughout the file

E.

to ease modification of formatting for all phone numbers

Question 2

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?

Options:

A.

one

B.

two

C.

three

D.

four

Question 3

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?

Options:

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

Question 4

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?

Options:

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.

Question 5

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

Options:

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

Question 6

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

Options:

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.

Question 7

Given a FileMaker Pro 8 database containing these two scripts::

Script A:

Perform Script ["Script B" ; Parameter: 3]

Show Custom Dialog [Get (ScriptResult)]

Script B:

Set Variable [$x; Value:Get (ScriptParameter)]

Loop

Set Variable [$result ; Value: $result + $x]

Set Variable [$x ; Value: $x - 1]

Exit Loop If [$x = 0]

End Loop

Exit Script [Result: $result]

If a user runs Script A, what value will be displayed in the custom dialog?

Options:

A.

0

B.

1

C.

6

D.

9

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

Options:

A.

?

B.

0

C.

-3, -2, -1

D.

-3, -2, -1, 0

Question 9

Which three occur if the hard disk runs out of space during a "live" backup of files hosted on FileMaker Server 8? (Choose three.)

Options:

A.

The backup stops.

B.

The backup file is deleted.

C.

The backup file is retained.

D.

The backup continues on another disk if one is available.

E.

FileMaker Server 8 logs an error in the Application Log (Windows) or Event.log (Mac OS).

Question 10

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

Options:

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

Question 11

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 12

What two statements are true for FileMaker Pro 8 Advanced? (Choose two.)

Options:

A.

The Data Viewer can only be used while debugging scripts.

B.

The Script Debugger allows you to view any currently running script.

C.

Using the Active Scripts pane in the Script Debugger, you can temporarily disable sub-scripts.

D.

Using the Set Next Script Step function in the Script Debugger, you can alter the order in which sub-scripts execute.

E.

Using the Halt Script function in the Script Debugger, you can stop the execution of a sub-script and return to the script that called it.

Question 13

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

Options:

A.

Indexing improves the speed at which finds are performed.

B.

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

C.

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

D.

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

E.

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

Question 14

Which statement is true?

Options:

A.

One FileMaker 8 Server may provide data to multiple Web Publishing Engines at one time.

B.

One Web Publishing Engine may draw data directly from multiple FileMaker 8 Servers at one time.

C.

A Custom Web Publishing application can integrate data from multiple Web Publishing Engines at one time.

D.

A Custom Web Publishing application can be load-balanced using multiple Web servers connected to a single FileMaker 8 Server.

Question 15

Which two statements are true about the [Full Access] privilege set? (Choose two.)

Options:

A.

It can be deleted and/or renamed.

B.

It must have at least one account associated with it.

C.

Another privilege set with the same functionality can be created.

D.

Associated accounts cannot log in over a network unless the [fmapp] extended privilege is enabled.

Question 16

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 17

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 18

Which two statements are true about custom functions? (Choose two.)

Options:

A.

They can be used in FileMaker Pro 8 by users with [Full Access] privileges.

B.

They can be edited in FileMaker Pro 8 by users with [Full Access] privileges.

C.

They can be edited in FileMaker Pro 8 Advanced by all users regardless of privilege set.

D.

They can be edited in FileMaker Pro 8 Advanced only by users with [Full Access] privileges.

Load More FM0-302 Questions
Demo: 18 questions
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF