Download PrepIQ Developer Essentials for FileMaker 10 Ultimate Exam and more Exams Technology in PDF only on Docsity!
FileMaker 10 Ultimate Exam
Question 1. Which FileMaker feature allows you to display related records from another table without leaving the current layout? A) Script Triggers B) Portals C) Value Lists D) Conditional Formatting Answer: B Explanation: Portals show related records in a layout, providing a window onto another table’s data while staying on the current record. Question 2. In FileMaker Pro 10, which calculation operator is used for string concatenation? A) & B) + C) * D) ^ Answer: A Explanation: The ampersand (&) joins two strings together, e.g., "First" & "Last" results in "FirstLast". The plus (+) is for numeric addition. Question 3. What is the default behavior of a FileMaker script when a “Perform Script” step encounters an error? A) The script stops automatically. B) The script continues to the next step. C) FileMaker rolls back any changes made. D) An error dialog is displayed and the script pauses. Answer: B Explanation: By default, scripts ignore errors and continue; you must use the “Set Error Capture” or “If [Get ( LastError )]” logic to handle errors. Question 4. Which of the following is NOT a valid relationship graph line type in FileMaker? A) Solid line B
FileMaker 10 Ultimate Exam
Question 4. Which of the following is NOT a valid relationship graph line type in FileMaker? A) Solid line B) Dashed line C) Dotted line D) Double line Answer: D Explanation: FileMaker supports solid, dashed, and dotted lines to indicate relationship types; a double line is not a defined option. Question 5. In FileMaker Pro 10, which script step would you use to delete a found set of records? A) Delete Record/Request B) Delete All Records C) Delete Found Set D) Delete Matching Records Answer: C Explanation: “Delete Found Set” removes all records currently in the found set, whereas “Delete All Records” clears the entire table. Question 6. What does the “Allow User to Create Records” privilege control? A) Ability to edit existing records B) Ability to import data C) Ability to add new records via layouts or scripts D) Ability to delete records Answer: C Explanation: This privilege determines whether a user can create new records; it does not affect editing or deletion. Question 7. Which calculation function returns the current date in FileMaker? A) Get ( CurrentTime ) B) Get ( CurrentDate )
FileMaker 10 Ultimate Exam
Explanation: This option permits the creation of child records on a layout that is based on the parent table, linking them through the defined relationship. Question 11. Which FileMaker function would you use to format a number as currency? A) Currency ( ) B) GetAsCurrency ( ) C) FormatCurrency ( ) D) NumberFormat ( ) Answer: B Explanation: GetAsCurrency converts a numeric value to a properly formatted currency string based on system locale. Question 12. What is the purpose of the “Set Variable” script step? A) To store a temporary value in memory for later use in the script B) To permanently add a field to a table C) To create a new layout object D) To define a relationship Answer: A Explanation: “Set Variable” creates a script-level variable that persists only for the duration of the script (or until cleared). Question 13. Which of the following is a valid way to sort records in a script? A) Sort Records [Restore; No dialog] B) Sort Records [Ascending] C) Sort Records [Field Order] D) Sort Records [Automatic] Answer: A Explanation: The “Sort Records” step can be set to use a saved sort order (Restore) and optionally suppress the dialog. Question 14. In FileMaker Pro 10, what does the “Layout Mode” allow you to do?
FileMaker 10 Ultimate Exam
A) View data records only B) Edit field definitions and layout objects C) Run scripts D) Perform data import Answer: B Explanation: Layout Mode is used for designing the visual layout, adding objects, and adjusting field properties. Question 15. Which of the following is NOT a type of field validation option in FileMaker? A) Unique value B) Not empty C) Max length D) Auto-increment Answer: D Explanation: Auto-increment is not a field validation option; you achieve it via a calculation or script, while the other three are built-in validation settings. Question 16. What does the “Allow user to view only their own records” privilege do? A) Limits the user to records they own based on the Owner field B) Prevents the user from editing any records C) Filters the found set to only records created by the user D) Both A and C are correct Answer: D Explanation: This privilege both restricts viewable records to those where the Owner field matches the user and automatically filters the found set accordingly. Question 17. Which script step would you use to import data from a CSV file into a FileMaker table? A) Import Records B) Load CSV C) Insert From URL
FileMaker 10 Ultimate Exam
Question 21. Which of the following is NOT a built-in FileMaker script trigger? A) OnObjectEnter B) OnLayoutLoad C) OnRecordCommit D) OnDatabaseClose Answer: D Explanation: FileMaker does not have an “OnDatabaseClose” trigger; the others are valid triggers for objects, layouts, and records. Question 22. In FileMaker, what is the effect of checking “Include related records” when performing an export? A) Only the current table’s fields are exported B) Fields from related tables are added as additional columns C) The export creates a new related table D) It merges records into a single field Answer: B Explanation: Selecting “Include related records” adds fields from related tables to the export file as separate columns. Question 23. Which of the following is the correct syntax for a FileMaker calculation that returns the day of the week for a given date? A) DayOfWeek ( Date ) B) Day ( Date ) C) Weekday ( Date ) D) GetAsNumber ( Date ) Answer: C Explanation: The Weekday function returns an integer (1-7) representing the day of the week for the supplied date. Question 24. What does the “Allow user to delete records” privilege control? A) Deleting records via scripts only B) Deleting records from any layout or script
FileMaker 10 Ultimate Exam
C) Deleting only records they own D) Deleting only records in the Trash table Answer: B Explanation: This privilege determines whether a user can delete records regardless of how the deletion is initiated. Question 25. Which FileMaker feature provides a way to enforce data integrity by preventing circular relationships? A) Relationship Graph validation B) Referential Integrity C) Circular Reference Check D) None of the above Answer: B Explanation: Referential integrity ensures that a child record cannot reference a non-existent parent, preventing circular dependencies. Question 26. In FileMaker Pro 10, which layout object can be used to display a summary field’s total across all records? A) Portal B) Summary field placed on the layout footer C) Text object with calculation D) Button Answer: B Explanation: Placing a summary field in the layout footer (or header) displays its aggregate value for the current found set. **Question 27. What does the “Conditional Formatting” feature allow you to do? ** A) Change the field type based on data B) Apply visual styles to objects when conditions are met C) Automatically generate scripts D) Restrict user access to records Answer: B
FileMaker 10 Ultimate Exam
A) 10
B) 50
C) 100
D) Unlimited (limited by system resources) Answer: D Explanation: FileMaker does not impose a hard limit; the practical limit depends on available memory and screen size. Question 32. Which script step would you use to change the current layout to a different one? A) Go to Layout B) Switch Layout C) Change Layout D) Set Layout Answer: A Explanation: “Go to Layout” navigates the user to the specified layout, optionally using a layout name or ID. Question 33. In FileMaker, what does the “Allow user to modify layout” privilege affect? A) Ability to edit records on the layout B) Ability to change the layout design in Layout Mode C) Ability to create new layouts via scripts D) Ability to export layout as PDF Answer: B Explanation: This privilege controls whether a user can enter Layout Mode and modify the layout’s objects and design. Question 34. Which calculation function would you use to retrieve the username of the currently logged-in account? A) Get ( AccountName ) B) Get ( UserName ) C) Get ( CurrentUser )
FileMaker 10 Ultimate Exam
D) Get ( LoggedInUser ) Answer: A Explanation: Get ( AccountName ) returns the name of the account that is currently logged into the FileMaker file. Question 35. What is the purpose of the “Set Error Capture [On]” script step? A) To force all errors to be ignored B) To suppress default error dialogs and allow custom handling C) To log errors to a file D) To reset the error flag to zero Answer: B Explanation: When error capture is on, FileMaker does not display its standard error dialogs, enabling the script to handle errors programmatically. Question 36. Which of the following is a correct way to reference a global field in a calculation? A) $$FieldName B) Global::FieldName C) @FieldName D) #FieldName Answer: A Explanation: Global fields are referenced with a double dollar sign prefix (e.g., $ $MyGlobal) in calculations. Question 37. In FileMaker Pro 10, which file format can be used for native import/export without any conversion? A) CSV B) Tab-delimited text C) XML D) FMP12 (FileMaker 12) Answer: D Explanation: FMP12 (or FMP10 for older versions) is the native FileMaker file format; importing or exporting it preserves all data structures without conversion.
FileMaker 10 Ultimate Exam
B) They require a separate table for the same data. C) They enable a table to relate to itself via a key field. D) They create duplicate records automatically. Answer: C Explanation: A self-join links a table to itself, often using a foreign key that points back to the primary key within the same table. Question 42. Which script step can be used to create a new record without navigating away from the current layout? A) New Record/Request B) Create Record C) Insert Record D) Duplicate Record Answer: A Explanation: “New Record/Request” creates a blank record in the current table and layout context without requiring a layout change. Question 43. In FileMaker, what does the “Get ( RecordID )” function return? A) The internal numeric ID of the current record B) The primary key field value C) The record’s position in the found set D) The UUID of the record Answer: A Explanation: Get ( RecordID ) provides the internal, system-generated record identifier, which is stable for the life of the record. Question 44. Which of the following is a valid way to limit a portal to show only the first three related records? A) Set portal filter to “Limit to 3” B) Use a portal filter calculation with “Get ( RecordNumber ) ≤ 3” C) Set the portal rows to 3 and enable “Show only related records” D) Portals cannot be limited; they always show all related records. Answer: B
FileMaker 10 Ultimate Exam
Explanation: A portal filter calculation can reference Get ( RecordNumber ) (or a related field) to restrict displayed rows; setting rows to 3 only affects layout size, not filtering. Question 45. Which of the following best describes the purpose of the “Perform Script on Server” step? A) Run a script locally on the client machine B) Execute a script on the FileMaker Server, freeing the client UI C) Transfer a script file to the server for editing D) Schedule a script to run at a later time Answer: B Explanation: “Perform Script on Server” sends the script to the server for execution, allowing the client to continue interacting without waiting for the script to finish. Question 46. What is the effect of checking “Allow user to define their own layout” in a privilege set? A) Users can create new layouts in Layout Mode. B) Users can rearrange fields on existing layouts. C) Users can save personal layout copies (custom layouts). D) Users can edit layout objects but not save them. Answer: C Explanation: This privilege lets a user create personal (custom) layouts that are saved under their account, without affecting the base design. Question 47. In FileMaker calculations, which function would you use to round a number to the nearest integer? A) Round ( ) B) Int ( ) C) Ceiling ( ) D) Truncate ( ) Answer: A Explanation: Round ( number ; decimalPlaces ) rounds to the specified number of decimal places; using 0 as the second argument rounds to the nearest whole number.
FileMaker 10 Ultimate Exam
A) Length ( ) B) Size ( ) C) Count ( ) D) CharCount ( ) Answer: A Explanation: Length ( text ) returns the character count of the supplied string. Question 52. What is the purpose of the “Set Field By Name” script step? A) To set a field value using a field name stored in a variable B) To rename a field in the schema C) To create a new field on the fly D) To change the display name of a field on a layout Answer: A Explanation: “Set Field By Name” allows dynamic field referencing by passing the field name as a text string, enabling flexible scripting. Question 53. Which of the following statements about “Calculated fields” is TRUE? A) They can be edited directly by the user. B) Their values are stored physically in the table. C) They are recomputed each time the record is accessed. D) They cannot reference other fields. Answer: C Explanation: Calculated fields are virtual; their value is evaluated on demand based on the defined expression. Question 54. Which FileMaker feature allows you to automatically generate a unique identifier for each new record? A) Auto-Enter Serial Number B) UUID function in a calculation C) Global field with increment script D) Both A and B are valid methods Answer: D
FileMaker 10 Ultimate Exam
Explanation: Auto-Enter Serial Number provides sequential IDs; a calculation using UUID() generates a globally unique identifier. Both are common approaches. Question 55. What does the “Show/Hide” script step control? A) Visibility of layout objects at runtime B) Whether a field is searchable C) User access to the file D) Export of hidden fields Answer: A Explanation: “Show/Hide Object” toggles the visibility of a specified layout object while the script is running. Question 56. In the Relationship Graph, what does a “double-arrow” line indicate? A) One-to-many relationship B) Many-to-many relationship through a join table C) A relationship that is set to “Allow creation” on both sides D) No special meaning; it is just a visual style. Answer: B Explanation: Double-arrow lines are typically used to represent a many-to-many relationship that passes through a junction (join) table. Question 57. Which script step can be used to change the current user’s password? A) Set Account Password B) Change Password C) Set Field [Account::Password] D) There is no script step; it requires manual change. Answer: D Explanation: FileMaker does not provide a script step to modify a user’s password; password changes are performed via the Admin Console or security settings.
FileMaker 10 Ultimate Exam
C) To store data fields only D) To set user privileges Answer: B Explanation: Layout parts segment the layout for printing and screen display, allowing repeated elements (e.g., headers) and page-specific content. **Question 62. Which of the following best describes a “Join Table” in FileMaker? ** A) A table that stores user login information B) A table that implements many-to-many relationships between two other tables C) A table that contains only calculated fields D) A table that cannot have its own layout Answer: B Explanation: A join (junction) table holds foreign keys from two related tables, enabling many-to-many relationships. Question 63. Which script step can be used to export a PDF of the current layout? A) Export Records as PDF B) Save Records as PDF C) Export Layout as PDF D) Save as PDF Answer: B Explanation: “Save Records as PDF” creates a PDF of the current layout (or a specified layout) and saves it to a file. Question 64. What does the “Get ( SystemPlatform )” function return? A) The operating system name (Windows, macOS) B) The version of FileMaker Pro C) The type of client (WebDirect, iOS, Desktop) D) The CPU architecture Answer: A
FileMaker 10 Ultimate Exam
Explanation: Get ( SystemPlatform ) returns an integer indicating the platform: 1 = macOS, 2 = Windows, etc. Question 65. Which of the following is NOT a valid way to sort records in Browse mode without a script? A) Click the column header in a list view B) Use the “Sort Records” dialog manually C) Right-click a field and choose “Sort Ascending” D) Press Ctrl+S on the keyboard Answer: D Explanation: Ctrl+S is the shortcut for saving a file, not for sorting records. Question 66. In FileMaker, what does the “Set Variable [$$var; Value: …]” syntax create? A) A local variable that exists only within the current script step B) A global variable accessible by all scripts and layouts during the session C) A field in the current record named $$var D) A temporary file on disk Answer: B Explanation: Variables prefixed with $$ are global and persist for the duration of the user’s session. Question 67. Which of the following statements about “Script Parameters” is TRUE? A) They can only be passed as text strings. B) They are stored in a global variable named $$scriptParam. C) They are accessed within the script using Get ( ScriptParameter ). D) They are only available to scripts run on the server. Answer: C Explanation: Get ( ScriptParameter ) returns the value passed to the script when it is invoked. **Question 68. What is the purpose of the “Allow user to export data” privilege? **
