FM0-305 Online Practice Questions and Answers

Which method can be used to sort related records within a portal in a FileMaker Pro 11 database?

A. In Layout Mode, rightclick on a field in the portal and choose Sort Portal from the contextual popup menu.

B. In Layout Mode, select the portal then choose Sort records in the Behavior section of the Data tab of the Inspector.

C. In the Relationships Graph, change the Sort records setting in the Specify Table dialog for the portal's table occurrence.

D. Run a script using the Sort Records [ ] script step, choosing the portal's table occurrence from the popup menu of the Sort related records checkbox option.

E. Change the Sort records setting in the Edit Relationship dialog for the last relationship leading to the portal's table occurrence from the context of the layout's table occurrence on the Relationships Graph.

The field exampleField has a script trigger set to activate OnObjectKeystroke and run the following script:

Allow User Abort [Off]

Set Error Capture [On]

If [Length (File::exampleField)= 7]

Exit Script [Result: 0]

Else

Set Field [File::exampleField File::Field and ""]

Exit Script []

End If

The field exampleField has the value of 111111.

At the end of the string a 9 is entered.

What is the resulting value in the field after the script trigger has processed?

A. 0

B. 111111

C. 111111

D. 1111110

E. 1111119

What can be retrieved using one of the Get functions?

A. the list of users logged into a file

B. the list of plugins installed for a user

C. the list of script triggers defined for a named object on a layout

D. the list of unique IDs for the current window's found set of records

E. the list of NIC addresses for network cards connected to the user's computer

A hosted FileMaker Pro 11 file contains a text field called ColorChoice that uses global storage. User A and User B are using the file. User A runs a script that changes the value in the ColorChoice field.

User A logs off and User B continues working. User B runs a script that modifies the ColorChoice field after User A has logged off.

If there is no other activity in the database, when User A logs back in, which value will User A see in the

ColorChoice field?

A. No value: the field will be empty.

B. The last value that User A's script entered into the field.

C. The last value that User B's script entered into the field.

D. The last value that was saved in a session that was running on the file's host.

Which two statements are true about the Admin account created in a new FileMaker Pro 11 database? (Choose two.)

A. It can be deleted.

B. It can be renamed.

C. It cannot be set to use external authentication.

D. It can only be assigned the [Full Access] privilege set.

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.

Which two are required to make a FileMaker Pro database accessible to remote applications using JDBC? (Choose two.)

A. The database is hosted using FileMaker Server 11 Advanced.

B. A properly configured DSN is installed on the computer hosting the database.

C. The ISAPI Filters must be enabled on Windows IIS (Internet Information Server).

D. A Java Virtual Machine (JVM) must be installed on the computer hosting the database.

E. The database has the [fmxdbc] extended privilege enabled in at least one privilege set associated with an active account.

Which three are necessary to create and publish a PHPbased Web site using the PHP Site Assistant? (Choose three.)

A. a copy of FileMaker Pro 11 Advanced

B. a working installation of FileMaker Server

C. a development computer with Java installed

D. a development computer with the PHP runtime engine installed

E. one or more hosted database files with the [fmphp] extended privilege enabled for at least one active user account

Which three are valid XML grammars for use with Custom Web Publishing (CWP)? (Choose three.)

A. fmresultset

B. fmrecordset

C. FMPXMLRESULT

D. FMPDSORESULT

E. FMPDBRESULT

F. FMPCWPRESULT

How should a database be configured so that users will NOT be prompted for a user name and password when accessing the database via Instant Web Publishing (IWP)?

A. replace the default IWP login page with a custom home page

B. enable the [Guest] account and ensure that it is the only active account with the [fmiwp] extended privilege enabled

C. ensure that at least one user account has the [fmiwp] extended privilege and that the password for the account is blank

D. create a script that uses the Relogin script step to log all users in as the [Guest] user, and set that script to run when the file opens