Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

FM0-302 FileMaker8 Developer Essentials Exam Questions and Answers

Questions 4

A layout contains a portal that allows creation of related records. What are two techniques that can be used to navigate to the empty row at the bottom of the portal? (Choose two.)

Options:

A.

use the script step Go to Portal Row [Select; Last]

B.

use the script step Go to NthRecord [fieldName; Last]

C.

assuming a field in the portal is in the tab order, click or tab to the first portal row then arrow down to the last row

D.

assuming a field in the portal is in the tab order, click or tab to the first portal row and continue to tab to the last row

Buy Now
Questions 5

Click the Exhibit button.

You have two fields, Pointer and Product. Each field is defined to have three repetitions, and the data shown in the exhibit.

What is the result of the following formula?

Let(

[

$i[1] = Pointer[1];

$i[2] = Pointer[2];

$i[3] = Pointer[3];

$result[$i[2]] = Product[$i+1]

];

$result

)

Options:

A.

1

B.

2

C.

Cherry

D.

Banana

Buy Now
Questions 6

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 7

Consider two FileMaker Pro 8 files, Alpha and Beta, where a table from Beta appears as an externally referenced table occurrence on Alpha's Relationships Graph. Which three statements are true? (Choose three.)

Options:

A.

Layouts in Alpha can display data from Beta.

B.

Alpha can contain multiple valid file references to Beta.

C.

It is impossible to lock records in both Alpha and Beta simultaneously.

D.

Layouts from Beta cannot be displayed in the same window as layouts from Alpha.

E.

A table occurrence from Beta is required on Alpha's Relationships Graph in order to call a script in Beta from Alpha.

Buy Now
Questions 8

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

Options:

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Buy Now
Questions 9

Which two statements are true about use of encryption in FileMaker 8? (Choose two.)

Options:

A.

Network traffic between FileMaker Pro 8 and an ODBC client can be encrypted.

B.

When FileMaker Pro 8 is a client of FileMaker Server 8, the network traffic between the two can be encrypted.

C.

When FileMaker Pro 8 is a client of another copy of FileMaker Pro 8, the network traffic between the two can be encrypted.

D.

If, when saving or sending a PDF file you assign a password, the file is encrypted and cannot be opened without the password.

Buy Now
Questions 10

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

Buy Now
Questions 11

A script containing steps that are not web compatible is triggered by a client using Instant Web Publishing. When the script reaches the first step that is not web compatible, it will _____.

Options:

A.

stop executing only if Allow User Abort [ ] is set to Off

B.

warn the user and prompt whether to Continue or Exit

C.

always skip over the unsupported step and continue executing

D.

skip over the unsupported step and continue executing only if Allow User Abort [ ] is set to Off

Buy Now
Questions 12

Which two statements are true for an account in a FileMaker Pro 8 database that is authenticated externally? (Choose two.)

Options:

A.

The database may be hosted on FileMaker Server 8.

B.

The account is authenticated via : External Server.

C.

The database may be hosted on FileMaker Pro 8 Advanced.

D.

The account must be a member of a privilege set with the External Account extended privilege enabled.

Buy Now
Questions 13

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 14

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.

Buy Now
Questions 15

What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)

Options:

A.

JDBC

B.

ODBC

C.

Excel files

D.

XML format

E.

HTML table format

Buy Now
Questions 16

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.

Buy Now
Questions 17

Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)

Options:

A.

Different windows in the same file can have a different menu set.

B.

The ability to open a new window from the menu may not be removed by using a Custom Menu set.

C.

A new window created using File Menu: Window > New Window will inherit the current active Menu set.

D.

Closing all file windows without quitting the FileMaker Pro 8 application will keep the last active Custom Menu set until the application is quit.

Buy Now
Questions 18

In FileMaker Pro 8, which two statements are true for layout setup options? (Choose two.)

Options:

A.

The Menu Set setting determines the default menu set to install for the layout.

B.

Show field frames when record is active determines the scroll bar behavior of portals.

C.

On a layout by layout basis, you can specify whether changes made to the layout when exiting Layout mode will be saved automatically.

D.

The Save record changes automatically layout options determine the behavior of record commits for the layout in browse mode.

Buy Now
Exam Code: FM0-302
Exam Name: FileMaker8 Developer Essentials Exam
Last Update: Nov 21, 2024
Questions: 120

PDF + Testing Engine

$130

Testing Engine

$95

PDF (Q&A)

$80