Download PrepIQ Developer Essentials for FileMaker 13 Ultimate Exam and more Exams Technology in PDF only on Docsity!
FileMaker 13 Ultimate Exam
Question 1. Which of the following statements about FileMaker 13’s calculation engine is true? A) It only supports basic arithmetic operators. B) It introduced the Let function for variable scoping. C) It removed support for the IsEmpty() function. D) It requires all calculations to be stored as text fields. Answer: B Explanation: The Let function was added in FileMaker 13, allowing temporary variables inside calculations for clearer, more efficient formulas. Question 2. In FileMaker 13, which layout mode lets you design a layout while preserving the current record’s data view? A) Browse mode B) Layout mode C) Preview mode D) Form mode Answer: B Explanation: Layout mode is used for designing layouts; it does not display record data, allowing you to modify objects without affecting the current record view. Question 3. What is the primary purpose of a value list in FileMaker 13? A) To store script steps B) To define field validation rules C) To provide a set of selectable items for a field D) To create relationship graphs Answer: C Explanation: Value lists supply predefined choices (e.g., drop-down, pop-up) that users can select when entering data into a field. Question 4. Which script step would you use to create a new record in the current table? A) New Window B) New Record/Request
FileMaker 13 Ultimate Exam
C) Duplicate Record D) Go to Record/Request/Page [First] Answer: B Explanation: “New Record/Request” creates a blank record in the current table context. Question 5. In FileMaker 13, what does the “Allow creation of records in this table” privilege control? A) Ability to edit existing records B) Ability to view layout objects C) Ability to add new records via scripts or UI D) Ability to delete records Answer: C Explanation: This privilege determines whether a user can create new records in the specified table. Question 6. Which of the following is a correct way to reference a field from a related table in a calculation? A) Table::Field B) RelatedTable::FieldName() C) GetField ( “RelatedTable::Field” ) D) TableName[RelatedTable].Field Answer: A Explanation: The syntax Table::Field accesses a field in a related table when a relationship exists. Question 7. What does the “Set Variable” script step do in FileMaker 13? A) Assigns a value to a global field B) Stores a temporary value for the script’s duration C) Changes a field’s data type D) Creates a new table occurrence Answer: B
FileMaker 13 Ultimate Exam
Question 11. When using the “Insert from URL” script step, which option determines how the data is stored? A) Target field B) Target layout C) Target table D) Target script Answer: A Explanation: The “Target field” option specifies where the retrieved data will be placed. Question 12. Which FileMaker 13 script step is used to change the current layout to another layout? A) Go to Layout B) Switch Layout C) Change Layout D) Move to Layout Answer: A Explanation: “Go to Layout” changes the active layout for the current window. Question 13. What does the “Allow user to modify own password” privilege affect? A) Ability to change any user’s password B) Ability to change the password of the currently logged-in account C) Ability to reset passwords via script D) Ability to view password fields in the database Answer: B Explanation: This privilege lets a user change only their own password, not others’. Question 14. Which calculation operator is used for string concatenation in FileMaker 13? A) + B) &
FileMaker 13 Ultimate Exam
C) ++
D) ::
Answer: B Explanation: The ampersand (&) concatenates two strings. Question 15. In FileMaker 13, what is the purpose of the “Conditional Formatting” feature? A) To hide fields based on user role B) To change the visual appearance of layout objects based on data values C) To create dynamic value lists D) To enforce field validation rules Answer: B Explanation: Conditional formatting changes colors, fonts, or styles of objects when specified conditions are met. Question 16. Which of the following is a correct way to call a custom function named “CalcTax” with two parameters? A) CalcTax ( Amount ; Rate ) B) CalcTax ( Amount , Rate ) C) CalcTax ( Amount : Rate ) D) CalcTax ( Amount / Rate ) Answer: B Explanation: Custom functions use commas to separate arguments: CalcTax ( Amount , Rate ). Question 17. What does the “Set Field” script step do? A) Creates a new field in the table definition B) Assigns a value to a field in the current record C) Locks a field for editing D) Generates a field index Answer: B Explanation: Set Field writes a value to a specified field in the current context.
FileMaker 13 Ultimate Exam
C) Date D) Container Answer: A Explanation: When you add a new field, FileMaker defaults to the Text type unless you specify otherwise. Question 22. Which of the following functions returns the number of characters in a text string? A) Length ( ) B) Count ( ) C) CharCount ( ) D) Size ( ) Answer: A Explanation: Length ( text ) returns the character count. Question 23. In FileMaker 13, what does the “Allow user to view only own records” privilege restrict? A) Access to specific layouts B) Ability to edit any record C) Visibility of records owned by the user’s account only D) Ability to export data Answer: C Explanation: This privilege limits a user’s view to records where the OwnerID matches their account. Question 24. Which script step can be used to display a custom dialog box? A) Show Custom Dialog B) Show Message C) Alert User D) Display Dialog Answer: A Explanation: “Show Custom Dialog” presents a dialog with customizable buttons and messages.
FileMaker 13 Ultimate Exam
Question 25. What is the purpose of the “Perform Script on Server” step? A) To run a script locally on the client machine B) To execute a script on the server, reducing client-side processing C) To schedule a script for later execution D) To debug script steps Answer: B Explanation: Performing a script on the server offloads processing, improving performance for large data operations. Question 26. Which of the following is a valid FileMaker 13 relationship operator? A) = B) == C) ≠ D) <> Answer: D Explanation: “<>” denotes “not equal to” in relationship criteria. Question 27. When creating a portal, which setting determines how many rows are displayed? A) Portal Width B) Number of Rows to Show C) Portal Height D) Scroll Bar Visibility Answer: B Explanation: “Number of rows to show” specifies the visible row count in a portal. Question 28. Which calculation function converts a number to text with a specific number of decimal places? A) Round ( ) B) FormatNumber ( ) C) GetAsText ( )
FileMaker 13 Ultimate Exam
Question 32. Which FileMaker 13 feature allows you to create a reusable set of script steps that can be called from other scripts? A) Script Triggers B) Script Parameters C) Script Libraries (Custom Functions) D) Sub-scripts (Script Calls) Answer: D Explanation: Calling another script from within a script creates a sub-script, allowing reuse of script logic. Question 33. What is the effect of setting a field’s “Auto-Enter” calculation to “Do not replace existing value”? A) The calculation runs only when a new record is created. B) The calculation runs every time the field is edited. C) The calculation never runs. D) The calculation runs only if the field is empty. Answer: A Explanation: “Do not replace existing value” means the auto-enter calculation populates the field only on creation, not on subsequent edits. Question 34. Which of these is a valid way to reference the current record’s primary key field named “ID”? A) ID B) Self::ID C) Get ( RecordID ) D) Get ( CurrentRecordID ) Answer: A Explanation: In the current context, simply using the field name (ID) references that field’s value. Question 35. In FileMaker 13, which script step can be used to pause script execution until the user clicks a button? A) Pause/Resume Script
FileMaker 13 Ultimate Exam
B) Wait Until [ Condition ] C) Show Custom Dialog (with “OK” button) D) Halt Script Answer: A Explanation: “Pause/Resume Script” stops execution and can optionally display a message; the script resumes when the user clicks “OK”. Question 36. Which layout view is best suited for entering a single record at a time with a form-like appearance? A) List view B) Form view C) Table view D) Browse view Answer: B Explanation: Form view displays one record per screen, ideal for data entry. Question 37. What does the “Get ( LayoutObjectNames )” function return? A) A list of all field names on the current layout B) A list of all layout objects (fields, buttons, etc.) on the current layout C) The name of the current layout D) The number of objects on the layout Answer: B Explanation: Get ( LayoutObjectNames ) returns a return-delimited list of every object on the layout. Question 38. Which of the following is a correct way to test for a null value in a calculation? A) IsEmpty ( Field ) B) IsNull ( Field ) C) Field = "" D) All of the above (any works) Answer: D Explanation: All three approaches correctly detect an empty or null field value.
FileMaker 13 Ultimate Exam
C) Arrange Records [ Field: LastName ] D) Sort By Field [ LastName ] Answer: A Explanation: “Sort Records” with a saved sort order or explicit field list sorts the found set. Question 43. In FileMaker 13, what does the “Allow user to edit own password” privilege NOT affect? A) Changing the password for other users B) Changing the password for the current account C) Resetting a forgotten password D) Viewing the password field in clear text Answer: D Explanation: Passwords are never displayed in clear text; this privilege only concerns changing the current user’s password. Question 44. Which of the following is a valid way to create a relationship that matches on a calculated key? A) Use a stored field only B) Use a calculation field set to “Do not store result” on both sides C) Use a global field on one side D) Use a portal on the layout Answer: B Explanation: Matching on a calculation field (unstored) allows dynamic key matching without storing the result. Question 45. What does the “Get ( SystemPlatform )” function return on a macOS client? A) 1 B) 2 C) 3 D) 0 Answer: B
FileMaker 13 Ultimate Exam
Explanation: SystemPlatform returns 1 for Windows, 2 for macOS, and 3 for iOS. Question 46. Which of the following options best describes a “portal row” in FileMaker 13? A) A separate table occurrence B) A visual representation of a related record within a portal C) A script step that duplicates a record D) A field type for storing multiple values Answer: B Explanation: Each row in a portal displays data from a single related record. Question 47. In FileMaker 13, what is the purpose of the “Commit Records/Requests” script step? A) To save changes made to the current record to the file B) To undo the last edit C) To duplicate the current record D) To close the current window Answer: A Explanation: Commit forces FileMaker to write any pending changes to disk. **Question 48. Which of the following is true about global fields in FileMaker 13? ** A) They are stored per user account. B) Their values persist across all records and sessions for the same user. C) They cannot be indexed. D) They are read-only. Answer: B Explanation: Global fields store a single value that is shared by all records for a given user session. Question 49. What does the “Set Error Capture [On]” script step do? A) Prevents the script from stopping on errors, allowing custom error handling B) Logs errors to a file
FileMaker 13 Ultimate Exam
Question 53. What does the “Allow user to edit any field” privilege control? A) Ability to modify layout objects B) Ability to edit data in any field regardless of field-level validation C) Ability to change field definitions in Manage Database D) Ability to export field data Answer: B Explanation: This privilege permits editing of all fields, bypassing field-level restrictions such as “Do not allow modification”. Question 54. Which of the following is a correct way to reference a field in a related table called “Orders” from the current layout’s table “Customers”? A) Orders::OrderID B) Customers::Orders::OrderID C) RelatedOrders::OrderID D) OrderID (Orders) Answer: A Explanation: Using the table occurrence name (Orders) followed by :: and the field name accesses the related field. Question 55. In FileMaker 13, which of the following is NOT a built-in script trigger? A) OnObjectEnter B) OnLayoutLoad C) OnRecordCommit D) OnTableDelete Answer: D Explanation: “OnTableDelete” is not a native trigger; triggers exist for objects, layouts, and records, but not for table delete events. Question 56. Which calculation operator has the highest precedence in FileMaker 13? A) + (addition) B) ^ (exponentiation)
FileMaker 13 Ultimate Exam
C) & (concatenation) D) = (equality) Answer: B Explanation: Exponentiation (^) is evaluated before multiplication/division, addition/subtraction, and concatenation. Question 57. What does the “Get ( UserLanguage )” function return? A) The language of the operating system B) The language set for the FileMaker account C) The language of the current layout D) The language of the script editor Answer: B Explanation: It returns the language preference stored in the user’s FileMaker account. Question 58. Which of the following script steps can be used to create a new window? A) New Window B) Open Window C) Create Window D) Show Window Answer: A Explanation: “New Window” opens a separate window with optional parameters. Question 59. In FileMaker 13, what is a “script parameter” used for? A) To pass data into a script when it is called B) To define a script’s timeout period C) To set the script’s privilege level D) To store global variables automatically Answer: A Explanation: Script parameters are values supplied at the time a script is invoked, accessible via Get ( ScriptParameter ).
FileMaker 13 Ultimate Exam
D) Get ( RecordNumber ) Answer: B Explanation: Get ( FoundCount ) returns the count of records that match the current find. Question 64. What does the “Set Print Settings” script step allow you to configure? A) Layout margins only B) Printer selection, page orientation, and scaling C) File export format D) Script execution speed Answer: B Explanation: Set Print Settings defines printer, orientation, paper size, and scaling for a print job. Question 65. Which script step can be used to retrieve the value of a field from a related record without navigating to that record? A) Go to Related Record B) Set Variable with Get ( RelatedField ) C) Set Variable [ $value ; Value: RelatedTable::Field ] D) Get ( RelatedField ) only works after navigation Answer: C Explanation: Directly referencing RelatedTable::Field inside Set Variable retrieves the related value without changing context. Question 66. Which of the following is a valid way to create a repeating field in FileMaker 13? A) Set field repetition count in Manage Database → Options → Repetitions B) Use the Repeat function in calculations C) Define the field as an array type D) Repeating fields are not supported in FileMaker 13 Answer: A Explanation: In Manage Database, you can specify the number of repetitions for a field.
FileMaker 13 Ultimate Exam
Question 67. What does the “Get ( IsEmpty )” function evaluate? A) Whether a field contains a zero value B) Whether a field contains any data (including spaces) C) Whether a field is null or contains an empty string D) Whether a field is indexed Answer: C Explanation: Get ( IsEmpty ) returns 1 if the field is empty (null or “”), otherwise
Question 68. In FileMaker 13, which script step can be used to change the current user’s privilege set? A) Set Privilege Set B) Log Out / Log In (with new credentials) C) Change Account Privilege D) No script step; it requires manual login Answer: D Explanation: Privilege sets are assigned at login; scripts cannot change a user’s privilege set without re-logging. Question 69. Which of the following functions returns a list of all the tables in the current file? A) Get ( TableNames ) B) List ( Tables ) C) Get ( FileTables ) D) Get ( TableList ) Answer: A Explanation: Get ( TableNames ) returns a return-delimited list of all tables. Question 70. What is the purpose of the “Allow user to view only own layout” privilege? A) To restrict users to a single layout regardless of role B) To hide all other layouts from the user’s navigation menu
