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

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

FileMaker FM0-302 FileMaker8 Developer Essentials Exam Exam Practice Test

Page: 1 / 12
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF

FileMaker8 Developer Essentials Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$52.5  $174.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Add to Cart
Question 1

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 2

Which two statements are true about script parameters in FileMaker Pro 8? (Choose two.)

Options:

A.

Script parameters can contain multiple delimited values.

B.

A sub-script inherits the script parameter from the script that called it.

C.

The Get(ScriptParameter) function returns the same result over the duration of a given script.

D.

Script parameters for scripts that are set to run when a file opens are set from the File Menu > File Options dialog.

Question 3

Given the formula:

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

What is the result?

Options:

A.

012

B.

201

C.

Computer Science

D.

Computer Science 012

E.

seventeen spaces followed by 201

Question 4

Which two must be configured for a Web Publishing Engine to interact with a specific FileMaker server? (Choose two.)

Options:

A.

the Web server's IP address in the FileMaker Server Administration Tool

B.

the Web Publishing Engine IP address in the FileMaker Server Administration Tool

C.

the Web Publishing Engine identifier and passcode in the FileMaker Server Administration Tool

D.

the FileMaker server's IP address or host name and Web Publishing Engine identifier in the Web Publishing Administration Console

Question 5

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

Options:

A.

Fields can only be validated by a single criterion.

B.

Field validation warnings may be triggered by scripts.

C.

Users can be prevented from overriding the validation warning.

D.

A script can be specified to run when manually entered field data fail validation.

E.

Users can be presented with a specific message that they will see when a field fails validation.

Question 6

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 7

Which two statements are true about sorted portals in FileMaker Pro 8? (Choose two.)

Options:

A.

If the portal contains fields from multiple tables, the relationship Sort records settings will not be inherited by the portal.

B.

If the relationship that defines the portal's record set includes a Sort records setting, the portal might inherit that sort order.

C.

If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will combine the Sort records settings of all of those relationships.

D.

If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will be based upon the relationship closest to the portal's table occurrence.

Question 8

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 9

Consider a FileMaker Pro 8 database hosted by FileMaker Server 8. Two users, A and B, are accessing the database at the same time, and both are viewing records with the same layout. User A runs a script that loops through a found set, changing data in each record. Which statement is true?

Options:

A.

User B may see changes to record data resulting from User A's script before the script completes.

B.

User B will not see any changes to record data resulting from User A's script until the loop in the script ends.

C.

User B will not see any changes to record data resulting from User A's script until the script completes in its entirety.

D.

User B will only see changes to data resulting from User A's script if the script contains a Commit Records/Requests [ ] script step.

Question 10

Databases hosted on FileMaker Server 8 are experiencing periods of intermittent slowness. The FileMaker Server Administration Tool shows an average Cache Hit % of 75. The Database Cache Reserve is currently set at 56 MB, and is set to Distribute cache flush over one minute. The server has 1 GB of RAM installed. Total size of all hosted FileMaker files is 300 MB. What should be done to correct the problem?

Options:

A.

Increase the database cache and increase the amount of time for the cache flush.

B.

Decrease the database cache and increase the amount of time for the cache flush.

C.

Decrease the database cache and decrease the amount of time for the cache flush.

D.

Increase the database cache and decrease the amount of time for the cache flush.

Question 11

Which script step in FileMaker Pro 8 can be used to check if a record is locked?

Options:

A.

Go to Field [ ]

B.

Open Record/Request [ ]

C.

Commit Records/Requests [ ]

D.

Go to Record/Request/Page [ ]

Question 12

Click the Exhibit button.

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

If you place the field Teachers::Name into the portal, the result is _____.

Options:

A.

The text is repeated in each row of the portal.

B.

The name of the teacher for the first enrollment record for this table.

C.

The name of the teacher for the class repeated in each row of the portal.

D.

The name of the teacher for the first related teacher value for each student enrolled.

Question 13

A FileMaker Pro 8 database has three separate windows open, each with its own found set and sort order. If a new window is opened, what will the new window inherit from the previously active window?

Options:

A.

only the current window's found set

B.

only the current window's found set and sort order

C.

only the current window's found set, sort order, and layout

D.

the current window's found set, sort order, layout, and current record

Question 14

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

Options:

A.

one server only

B.

two servers only

C.

three servers only

D.

one or two servers only

E.

one, two, or three servers

Question 15

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?

Options:

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.

Question 16

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 17

A file has two layouts, Form and List. Form uses the [File Default] Menu Set. List uses a Custom Menu Set called List Menu.

The file default is set to [Standard FileMaker Menus]. The file has two scripts. Script A installs the Custom Menu Set List Menu. Script B installs the same Menu Set, but also includes the Use As File Default option.

If you are on the List layout, which statement is true?

Options:

A.

You run Script A, then switch to the Form layout and the List Menu Menu Set is active.

B.

You run Script B, then switch to the Form layout and the List Menu Menu Set is active.

C.

You run Script B, then switch to the Form layout and the [Standard FileMaker Menus]Menu Set is active.

D.

You switch to the Form layout, run Script A, then choose New Window and [Standard FileMaker Menus] is active.

Question 18

Which two settings affect an Account that is authenticated via FileMaker but not an Account that is authenticated via an External Server? (Choose two.)

Options:

A.

Manage extended privileges

B.

Allow user to modify their own password

C.

User must change password on next login

D.

Disconnect user from FileMaker Server when Idle

Load More FM0-302 Questions
Page: 1 / 12
Total 120 questions
Get FM0-302 Full Access Download FM0-302 PDF