Online Access Free FM0-307 Exam Questions

Which statement is true about portals in FileMaker Pro 12?

• A.Records in a portal can become unsorted if the developer unchecks "Keep records in sorted order" in the Portal Setup > Sort Records dialog.
• B.If there are multiple portals on a layout, the Go to Portal Row [First] script step will activate the portal closest to the top left corner of the layout.
• C.A portal set with only a bottom anchor containing fields set with only a top anchor will increase row height as the layout is expanded vertically.
• D.An OnObjectEnter script trigger applied to a portal will activate once for each portal row as a user tabs from field to field across rows.
• E.Conditional formatting can be applied to a portal row.

Which two statements are true when considering encrypted storage of data in a FileMaker Pro 12 database? (Choose two.)

• A.FileMaker account passwords are stored as a one-way hash.
• B.Container data that is stored externally in Secure storage is encrypted.
• C.Data in a text field is stored encrypted when the field option is checked for storage to Use encrypted storage
• D.Data that has been stored in an encrypted format in MySQL cannot be imported into a FileMaker database.
• E.The formula Encrypt (Table:: MyText; "MD5" ) can be used to create a hash of the contents of MyText.

Assume the user has full privileges to view and modify all data in the file. Which two statements are true in this situation? (Choose two.)

• A.The script step insert Text [Select; Customer:: z_TempText; "Complete"] will result in Error 102 ("Field is missing") and z_TempText will be empty.
• B.If viewed as a form in Browse mode, Quick Find will ignore the data in the Name Last field.
• C.The Activities portal, Name Last field, and z_TempText field are within the page boundary and thus will be included when printed in Form view.
• D.The user will be able to edit the contents of z_TempText in Table view.
• E.The Name Last field is in the Header part.
• F.The Name Last field will be excluded from the list of available fields in the Sort Records... dialog for the Current Layout

Which statement is true regarding applying object styles in FileMaker Pro 12?

• A.Holding down the Alt (Windows) or Option (Mac OS X) key while clicking the Copy Object Style button in Inspector will only copy the styles for the currently selected object state.
• B.The Format Painter tool can only apply styles associated with the Normal State of an object.
• C.The Format Painter cannot be used to apply the style of one layout part to another.
• D.The Format Painter will only apply styles to objects on the same layout.
• E.The Copy Object Style and Paste Object Style buttons of the Inspector will only work among layouts of the same file.

Given the following function:
Substitute (myText ; ["abc" ; "XYZ"] ; [ "XY2" ; "abc"])
If the field myText contains "abc-xyz", what is the result?

• A.XYZ-xyz
• B.XYZ-abc
• C.abc-xyz
• D.abc-abc