FM1-306 무료 덤프문제 온라인 액세스

Which three field options may be set for a shadow field from an External ODBC Data Source? (Choose three.)

• A.Auto-enter: creation date
• B.Validation: validated by calculation
• C.Storage: Minimal Indexing
• D.Validation: existing value
• E.Validation: unique value
• F.Auto-enter: serial number, on commit

A text field called FirstLast in FileMaker Pro 12 is set to auto-enter the following formula:
FirstName & " " & LastNarne
FirstName and LastNarne are text fields in the same table. The option Do not evaluate if all referenced fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked.
Under which two circumstances will the value of the calculation be inserted into the FirstLast field? (Choose two.)

• A.any field value on the record is modified and the FirstLast field is empty
• B.each time the value of the FirstName or LastNarne field is modified
• C.a user selects the menu item Records > Relookup Field Contents
• D.the FirstName or LastNarne field is modified and the FirstLast field is empty
• E.a record is first created

Which statement is true about the sort order of data in portals in FileMaker Pro 12?

• A.If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will be sorted based upon the relationship closest to the portal's table occurrence.
• B.If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will combine the Sort records settings of all of those relationships, sub-sorting by the relationships closest to the portal's table occurrence.
• C.The sort setting applied to the portal in Layout mode can only include fields from the portal's table.
• D.If the relationship that defines the portal's record set includes a Sort records setting, any sort setting applied to the portal in Layout mode will be ignored.
• E.If the relationship that defines the portal's record set includes a Sort records setting, unindexed fields in the sort setting will be ignored.

Which two events can activate an OnObjectEnter script trigger? (Choose two.)

• A.Switching from one tab to another in a tab control
• B.Navigating from one row in a portal to another
• C.Tabbing to a button
• D.Clicking a button

Which statement is true about the Filter Portal Records feature in FileMaker Pro 12?

• A.The portal filter formula must refer to at least one field in the immediately related table.
• B.Aggregate functions (e.g., Sum, Count) based on the portal's relationship will not be affected by the portal's filter formula.
• C.The portal filter formula may not refer to any globally stored fields, summary fields, or unstored calculation fields.
• D.There can be one unique filter formula applied for each portal state (Normal State, In Focus, Hover, or Pressed)
• E.The feature requires one or more additional relationships to be added to the Relationships Graph.