FM0-305 Online Practice Questions and Answers

What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 11 Advanced?

A. 10,000

B. 32,000

C. 50,000

D. 64,000

Consider a FileMaker Pro 11 database with the following tables and fields: Assuming only the above relationships between table occurrences, using sorting if necessary, which two actions can be performed? (Choose two.)

A. create a value list that shows all Invoices for a chosen Customer

B. create a value list on a Product layout which displays all Customers

C. find all of the Customers who have ever ordered a specific Product

D. create a portal to display each Product that has been ordered by a Customer

E. display all records from the Customer table in a portal on a layout for an Invoice Item record

Given the following two calculation fields, Time1 and Time2:

Time1 (Calculation, Time result) = Time ( 5 10 15 )

Time2 (Calculation, Time result) = Time1 + 60

What is the value of Time2?

A. 5:10:75

B. 18675

C. 5:11:15

D. 6:10:15

E. 65:10:15

Given a custom function created in FileMaker Pro 11 Advanced called Explode with a single parameter str

defined as:

Case ( Length ( str ) > 1

Explode ( Left ( str Length ( str ) 1

) )

and "?" and

Left ( str Length ( str ) 1

)

str )

What is the result of Explode ( "Bob" )?

A. Bo B

B. B Bo

B

C. B B Bo

D. Bob B Bo

E. B Bo Bob

F. Bob Bo B

Given a FileMaker Pro 11 database with the following script:

Perform Find [Restore]

# Find restores criteria: Customer::Name [Smith]

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::Name field contains "Smith"? (Choose two.)

A. Unless a Set Error Capture [On] step is added at the beginning of the script, Get (LastError) will not return an error value.

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

C. Adding a Set Error Capture [On] step to the beginning of the script will cause a default FileMaker error dialog to display, followed by the custom error dialog.

D. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.

A FileMaker Pro 11 file contains the following script: Show All Records Unsort Records Set Variable [$counter Get(FoundCount)] Go To Record/Request/Page [First] Loop Duplicate Record/Request Go To Record/Request/Page [First] Omit Record Set Variable [$counter Value: $counter 1] Exit Loop If [$counter=0] End Loop How many records will the table contain after this script is done executing, if the script begins execution in

a database table containing six records total?

A. 6

B. 12

C. 13

D. 24

E. The script will not finish executing but will loop until forcibly terminated.

A FileMaker Pro 11 file has a Customer table and a related Contact table. The relationship from Customer to Contact is configured to create related records in the Contact table. On the Relationships Graph, an external table occurrence called Invoice is referenced and is related to the Customer table. The file has layouts based on the Customer, Contact, and Invoice table occurrences.

The following script is used:

Script A:

New Record/Request

A button that performs Script A has been placed on the Customer layout in a portal that displays the

related Contact records.

Which two statements are true? (Choose two.)

A. When the button is clicked, a new record is created in the Contact table.

B. When the button is clicked, a new record is created in the Customer table.

C. If the user is on the Contact layout and runs Script A from the Scripts menu, a new record will be created in the Contact table.

D. If the user is on the Customer layout and runs Script A from the Scripts menu, a new record is created in the Customer table, and a new related record is created in the Contact table.

E. Without a Go to Layout script step, Script A cannot be run from the Scripts menu and create a new record in the Invoice table.

Which two script steps, if executed by a user in a hosted file with multiple loggedin users, can affect the active sessions of other users? (Choose two.)

A. Insert From Index

B. Set Field By Name

C. Enable Account [Deactivate]

D. Refresh Window [Flush cached join results]

E. Install Menu Set ["My Menu Set" Use as file default]

F. Set Variable [$$globalUserCount Value: $$globalUserCount + 1]

What is the minimal requirement to add an external FileMaker data source table occurrence of Inventory from a file called DEPT to the Relationships Graph of a file called PROD?

A. an active account associated with the [Full Access] privilege set in both PROD and DEPT

B. an active account associated with any privilege set for PROD and any privilege set that can view Inventory in DEPT

C. an active account associated with a privilege set that has the Manage External Data Sources option checked in both PROD and DEPT

D. an active account associated with the [Full Access] privilege set in PROD and an active account for DEPT associated with any privilege set that can view Inventory

E. an active account associated with a privilege set that has the Manage External Data Sources option checked in DEPT and a valid account with the [Full Access] privilege set in PROD

For serverhosted databases, FileMaker Server 11 Advanced is required for which three operations? (Choose three.)

A. importing ODBC data

B. acting as an ODBC data source

C. sharing via Custom Web Publishing

D. sharing via Instant Web Publishing

E. accessing External SQL data sources

F. sharing to more than 250 simultaneous FileMaker Pro users

Which two statements are true concerning Administrator Groups in FileMaker Server 11? (Choose two.)

A. Administrator Groups may be nested.

B. The Administrator Groups feature is only available in FileMaker Server 11 Advanced.

C. A group administrator can disconnect clients from databases in their Administrator Group.

D. A group administrator can limit the numbers of clients that can access hosted files within their Administrator Group.

E. A group administrator can change the FileMaker security settings for all databases in their Administrator Group.

Two users, userA and userB, are connected to the same database with two separate FileMaker Pro 11 clients. They are both viewing the same record on a layout based on an External ODBC Data Source (ESS). UserA changes the firstname field value from "Kim" to "Lindsey". What will occur to the record for userB when userA commits the record?

A. The firstname field will continue to display "Kim".

B. The firstname field will display "".

C. The firstname field will be updated to display "Lindsey".

D. A dialog is displayed indicating the record has been changed.

Which operation requires a database file to be open in FileMaker Pro 11?

A. performing a File Maintenance option

B. creating a copy of a file in which the OnFirstWindowOpen script is disabled

C. performing the Export Records command from a menu, script or script trigger

D. creating a copy of a file based on its logical structure (same as Compacted Copy)

Which two statements are true about the Status Toolbar? (Choose two.)

A. Record navigation via the Status Toolbar can be prevented by installing a Custom Menu.

B. The name and/or function of a status toolbar button can be changed by installing a Custom Menu.

C. The ability to add or remove buttons on the Status Toolbar can be prevented by installing a Custom Menu.

D. Users whose privilege set has Available menu commands set to Minimum cannot customize the Status Toolbar.

E. The initial settings of the Status Toolbar are stored with the database file and shared with all users of the hosted file.

F. Customization of the Status Toolbar can be prevented by running a script which contains the Show/ Hide Status Area [Lock Show] script step.

Which two statements are true about overriding the default behavior of the Quick Find box available in the Status Toolbar? (Choose two.)

A. The Perform Quick Find custom menu item must be installed.

B. The Show/Hide Quick Find script step will allow the user to hide the Quick Find box.

C. The Get( QuickFindText ) function will return the text entered into the Quick Find box.

D. A Layout based script trigger can be used to override a find request issued from the Quick Find box.