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

FM0-302 FileMaker8 Developer Essentials Exam Questions and Answers

Questions 4

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

Buy Now
Questions 5

Which three text functions are case sensitive? (Choose three.)

Options:

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Buy Now
Questions 6

Given the formula:

Choose( Qty / 100; 0; 2; 4; 6; 8 )

If the field Qty contains the value 250, what is the result?

Options:

A.

0

B.

2

C.

4

D.

6

E.

8

Buy Now
Questions 7

Click the Exhibit button.

Your database has four tables: Customer, Invoice, Line Item, and Product. The relationships are displayed in the Relationships Graph exhibit.

Your users want to select a group of customers and then view all unique products purchased by those customers.

Which two techniques successfully accomplish this without changing the Relationships Graph? (Choose two.)

Options:

A.

You build a portal on a Customer layout that shows related Product records.

B.

You write a script that uses a Go To Related Records [ ] script step to navigate from a Customer layout to the desired set of Product records.

C.

You create a button on a special Customer layout that performs a Copy All Records/Requests[ ] script step and allows users to paste the result into a Find request.

D.

You loop through the found set of Customer records, assembling a set of ID values into a global variable. You then loop again on a Products layout, creating single find requests for each ID value.

Buy Now
Questions 8

For FileMaker Pro 8 files that are opened (i.e. to resolve a relationship) and where the window remains hidden, which statement is true about a script set to perform When opening this file?

Options:

A.

It will not execute.

B.

It will execute as soon as the file is opened.

C.

It will execute as soon as the first window is drawn.

D.

It will execute when the file is opened only if the script has the run script with full access privileges option enabled.

Buy Now
Questions 9

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

Buy Now
Questions 10

Consider a FileMaker Pro 8 database with the following tables and fields:

Customer: customer_id, first_name, last_name

Order: order_id, customer_id, order_date

Product_Orders: order_id, product_id, quantity_ordered

Product: product_id, product_name, unit_price

Using only Cartesian cross-product ("x") relationships between table occurrences, sorting if necessary, which two actions can be performed? (Choose two.)

Options:

A.

determine the date of the most recent order

B.

display all records from the Customer table in a portal

C.

create a value list that shows all orders for a chosen customer

D.

create a portal to show one record for each product that has ever been ordered

Buy Now
Questions 11

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

Buy Now
Questions 12

Given a FileMaker Pro 8 database with this script:

Perform Find [Restore]

#Find restores criteria: Customer::City: [XXXX]

Refresh Window

If [Get ( LastError )]

Show Custom Dialog ["No records found"; "No records matched your find criteria."]

End If

Which two statements are true if there are no records where the Customer::City field contains "XXXX"? (Choose two.)

Options:

A.

The user will see a default FileMaker error dialog stating that no records match this set of find requests.

B.

Adding a Set Error Capture [On] step to the beginning of the script will suppress the custom dialog.

C.

Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.

D.

Adding a Set Error Capture [On] step to the beginning of the script causes the FileMaker Pro 8 error dialog to display and then the custom dialog will display its error message.

Buy Now
Questions 13

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.

Buy Now
Questions 14

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

Buy Now
Questions 15

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.

Buy Now
Questions 16

Which two statements regarding the Go to Related Records [ ]script step are true? (Choose two.)

Options:

A.

You can specify any layout in the current file as the destination layout.

B.

You have the option to display the related records in any of the file's existing windows.

C.

If there are no related records, the found set on the destination layout will not be altered in any way.

D.

You have the option to show records related to the current record only or to all the records in the found set.

Buy Now
Questions 17

Given the formula:

1 and (1 & 1)

What is the numeric result?

Options:

A.

0

B.

1

C.

2

D.

12

Buy Now
Questions 18

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

Buy Now
Exam Code: FM0-302
Exam Name: FileMaker8 Developer Essentials Exam
Last Update: Dec 27, 2024
Questions: 120
FM0-302 pdf

FM0-302 PDF

$25.5  $84.99
FM0-302 Engine

FM0-302 Testing Engine

$30  $99.99
FM0-302 PDF + Engine

FM0-302 PDF + Testing Engine

$40.5  $134.99