FM0-305 Online Practice Questions and Answers

Which statement is true about supplemental fields added to a table occurrence based on an External ODBC Data Source that uses MySQL?

A. These fields may be indexed.

B. All nontext data types are converted to text.

C. These fields may only be of type Summary or Calculation.

D. These fields will be added to the table definitions within MySQL.

E. These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the FileMaker Pro Manage Database dialog is used.

Which two statements are true about OnTimer triggers? (Choose two.)

A. They only run when the application is idle.

B. OnTimer triggers are configured in the File Options dialog.

C. Different OnTimer scripts can be installed in different windows.

D. Days and times can be specified when the OnTimer script activates.

For which two actions will FileMaker Pro 11 NOT preserve Sort Order for records being browsed, by reordering or resorting the found set following the action? (Choose two.)

A. selecting the Records > Show Omitted Only menu item

B. adding records to the table using File > Import Records > File...

C. modifications to a field's data caused by choosing Relookup Field Contents for a field used to specify the current sort order

D. modifications to schema for instance redefining a field type from Number to Text when that field is used to specify the current sort order

E. in Browse mode, rightclick a field that is used as a a field used to specify the current sort order and choose the Extend Found Set popup menu item to add some matching records to the found set

Given the following return delimited data in a Team field of a FileMaker Pro 11 database:

Andy Jones Bernie Lee

Carry Lane

Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team?

A. ListValues ( Team 2 )

B. GetWords (Team 3 2)

C. Middle (Team 12 10)

D. MiddleWords (Team 3 4)

E. MiddleValues (Team 2 1)

In which two cases will the object name of a button be available to a script that is performed by the button? (Choose two.)

A. when the Self function is used as the script parameter associated with the button's script

B. when the button is clicked on and the Get ( ActiveLayoutObjectName ) function is used in the script

C. when the button's object name is hardcoded into the script parameter associated with the button's script

D. when the button is tabbed to and then activated from the keyboard and the Get ( ActiveLayoutObjectName ) function is used in the script

Which three are valid types listed in the FileMaker Pro 11 Export Records to File dialog? (Choose three.)

A. PDF

B. XML

C. XSL

D. DBF

E. HTML Table

F. Access (.mdb)

Which two are required for a FileMaker Pro 11 user to access a supported external SQL Source (ESS) from a file being hosted by FileMaker Server 11? (Choose two.)

A. the [fmxdbc] extended privilege assigned to the user's privilege set

B. the ODBC/JDBC setting enabled in the FileMaker Server 11 Admin Console

C. a compatible ODBC driver installed on the FileMaker Server computer or the user's local computer

D. a validated path to the Data Source listed under the File Path List in the Edit Data Source dialog

E. an External ODBC Data Source in the Manage External Data Sources dialog for the hosted FileMaker database

The components of FileMaker Server 11 or FileMaker Server 11 Advanced may be installed on how many servers?

A. 1 server only

B. 1 or 2 servers only

C. 1, 2, or 3 servers only

D. 1, 2, 3, or 4 servers

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)

In FileMaker Pro 11 Advanced, which two statements are true about the Data Viewer and Script Debugger? (Choose two.)

A. The Current tab of the Data Viewer can be used to modify the value of a variable.

B. The Script Debugger will be invoked when a script is run from a button, but not from a Custom Menu.

C. The Watch tab of the Data Viewer can be used to create global variables when the user has [Full Access] privileges in a file.

D. The Current tab of the Data Viewer can be used to modify the value of a field with global storage while a script is paused in the Script Debugger.