FM0-305 Online Practice Questions and Answers

Given a text field myText that contains "blue", which formula extracts the word "blue" from the field?

A. Filter (myText "color")

B. MiddleWords (myText 2)

C. PatternMatch (myText "blue")

D. Middle ( myText Position ( myText "blue" 1 1 ) 4)

Which three are directly selectable options in the Validation tab of the field options dialog in FileMaker Pro 11? (Choose three.)

A. Existing value

B. Member of value list

C. Strict data type: Integer

D. Strict data type: Time of Day

E. Strict data type: Alphanumeric

F. Minimum number of characters

Which three FileMaker Pro 11 objects will display data contents even when unrelated to the current layout's table occurrence? (Choose three.)

A. Merge variable

B. Indexed Timestamp field

C. A Text field from a shadow table

D. Globally stored Calculation field

E. Globally stored Number field placed in a portal

F. A Container field defined with the Store as reference only option enabled

Which three statements are true about a Web Viewer object placed on a layout in a FileMaker Pro 11 file? (Choose three.)

A. It can be defined as a button.

B. It can support ActiveX controls (on Windows).

C. It can render valid HTML (including CSS styles) stored in a global variable.

D. It can be configured to show a Back button in the Web Viewer Setup dialog.

E. It can be configured to log into a secured web sites by sending the current user's FileMaker Pro account name and password.

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.

Which two actions can be performed via scripts? (Choose two.)

A. delete an account

B. deactivate a privilege set

C. create an extended privilege

D. enable an extended privilege for a privilege set

E. change the password of another user's account

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 statements are true when FileMaker Server 11 is set to Secure connections to FileMaker Server? (Choose two.)

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

B. Connections between FileMaker Server 11 and FileMaker Pro 11 are encrypted.

C. Connections between FileMaker Server 11 Advanced and XML clients are encrypted.

D. Connections between FileMaker Server 11 Advanced and ODBC clients are encrypted.

E. Connections between FileMaker Server 11 Web Publishing Engine and the web server are encrypted.

Which three are necessary to access a FileMaker Pro database hosted via Instant Web Publishing (IWP)? (Choose three.)

A. JavaScript enabled in the web browser

B. a working installation of FileMaker Server

C. a supported web browser (Firefox, Internet Explorer, or Safari)

D. at least one user account in the database with the [fmiwp] extended privilege enabled

E. a web server connected to an authentication server (Apache + OpenDirectory on Mac OS, or IIS + Active Directory on Windows)

F. a web server with the correct IWP plugin (mod_iwp for Apache, or the iwp.dll ISAPI filter for IIS)

Which two statements are true about windows in a FileMaker database? (Choose two.)

A. A given user may have a maximum of 100 windows open concurrently.

B. Creation of a new window will activate an OnLayoutEnter script trigger.

C. On the Windows platform, only the currently active window can be maximized.

D. The Adjust Window script step can be used to move a window to a location specified by a calculation formula.