Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

FileMaker FM0-302 FileMaker8 Developer Essentials Exam Exam Practice Test

Demo: 18 questions
Total 120 questions

FileMaker8 Developer Essentials Exam Questions and Answers

Question 1

Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)

Options:

A.

Copy to a remote hard drive.

B.

Use the Save a Copy As command.

C.

Use an OS script to pause and copy files.

D.

Trigger a "Live" backup from a command line.

E.

Use a "Live" backup scheduled in the FileMaker Server 8 Task Scheduling assistant.

Question 2

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 3

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 4

Click the Exhibit button

Consider a FileMaker Pro 8 database with two tables called Salesperson and Order, and a relationship between the two tables based on a SalespersonID field. The relationship is configured as shown in the exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a portal showing Order records via the above relationship.

Which three statements are true? (Choose three.)

Options:

A.

Deleting a Salesperson record also deletes all related Order records.

B.

It is possible to create new Salesperson records by importing data into the Order table.

C.

It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in the context of the Order table occurrence.

D.

Users may create new Order records by entering data into the portal on the Salesperson Detail layout.

E.

It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a layout that is based on the Order table occurrence.

Question 5

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 6

When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)

Options:

A.

Secure connections are typically faster because of data encryption.

B.

Secure Sockets Layer (SSL) is used by FileMaker Pro 8 client connections.

C.

Connections between FileMaker Server 8 and FileMaker Pro 8 are encrypted.

D.

Connections between FileMaker Server 8 Advanced and XML clients are encrypted.

Question 7

On conversion to FileMaker Pro 8, what does the old password from FileMaker Pro 6 become?

Options:

A.

a privilege set

B.

only the account name

C.

only the account password

D.

both an account name and account password

Question 8

While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:

Show All Records

Go to Record/Request/Page [First]

Loop

If [Customer::Category <> "A"}

Omit Record

Else

Go to Record/Request/Page [Next; Exit after last]

End If

Exit Loop If [Get ( FoundCount )= 0]]

End Loop

After the script stops running, which two statements are true? (Choose two.)

Options:

A.

All customer records in Category A are omitted.

B.

If there are no Category A records, the found set is 0.

C.

All customer records in Category A are in a found set.

D.

If there are no Category A records, the found set is all records.

Question 9

What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?

Options:

A.

64 kilobytes

B.

2 gigabytes

C.

8 terabytes

D.

The number is limited only by disk space.

Question 10

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

Options:

A.

Adjust Window [ ]

B.

Enter Browse Mode [ ]

C.

Enter Preview Mode [ ]

D.

Enter Find Mode [Pause]

E.

Move / Resize Window [ ]

Question 11

A database has two tables, Planet and Moon. Moons are related to a single planet and their relationship is set to delete related records in the Moon table when a Planet record is deleted.

Which two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog? (Choose two.)

Options:

A.

All data in the Planet table are deleted.

B.

All records in the Moon table are deleted.

C.

All records in the Moon table remain unaffected.

D.

All records in the Moon table are deleted if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.

Question 12

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 13

A layout showing records from a People table has the Save record changes automatically checkbox disabled in the Layout Setup dialog. Which two actions cause FileMaker Pro 8 to display a dialog asking whether or not you want to save changes to the current record? (Choose two.)

Options:

A.

importing records into the People table

B.

editing a field value on the layout and attempting to commit the record

C.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[No Dialog] script step

D.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[Skip data entry validation] script step

Question 14

Click the Exhibit button.

Given the FileMaker Pro 8 Relationships Graph shown in the exhibit, which table occurrence should be assigned to a layout that contains a portal that shows all students for all of a teacher's classes?

Options:

A.

Classes

B.

Advisors

C.

Teachers

D.

Enrollment

Question 15

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 16

Click the Exhibit button.

You want to build a FileMaker Pro 8 database that models family relationships. One person may have many children. One person may also have many "parents" (including biological parents, guardians, step-parents, etc.).

You want to build the system in such a way that a single layout showing information about a person can also display two portals, one showing the names of all of the current person's children (if any) and the other showing the names of all of the current person's parents (if known).

Assume that personal names exist in only one table. There are no lookup fields or calculation fields in any tables, and there are no scripts in the file.

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.

five

Question 17

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

Options:

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

Question 18

In the Fields tab of the Define Database dialog in FileMaker Pro 8, which two are valid field types? (Choose two.)

Options:

A.

Time

B.

Image

C.

Global

D.

Repeating

E.

Timestamp

Demo: 18 questions
Total 120 questions