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

FileMaker FM0-302 - FileMaker8 Developer Essentials Exam

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

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

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?

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.

The last script step in Script A in File A calls Script B in File B. Which three script steps can be used in Script B to make File B's front most window active without the need to use the Select Window [ ] script step? (Choose three.)

A.

Adjust Window [ ]

B.

Enter Browse Mode [ ]

C.

Enter Preview Mode [ ]

D.

Enter Find Mode [Pause]

E.

Move / Resize Window [ ]

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.

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.

What is the maximum number of files that can be hosted on FileMaker Server 8?

A.

125

B.

250

C.

500

D.

The number is limited only by server hardware.

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

Which two statements are true about the [Guest] account that is included by default when creating a new FileMaker Pro 8 database? (Choose two.)

A.

It is not enabled.

B.

It cannot be deleted.

C.

It can log in without entering a password.

D.

It can log in using Instant Web Publishing without entering either a username or password.

Which two scripts steps in FileMaker Pro 8 lock a record? (Choose two.)

A.

Set Field [ ]

B.

Select All [ ]

C.

Go to Field [ ]

D.

Open Record/Request [ ]