Crack4sure Logo
3 Months Free Update
3 Months Free Update
3 Months Free Update
Click the Exhibit button.
You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may manage zero or more people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can display both the name of the current person's manager (if any) and the names of all people managed by the current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?
A script containing steps that are not web compatible is triggered by a client using Instant Web Publishing. When the script reaches the first step that is not web compatible, it will _____.
The return delimited data in the Contact field of a FileMaker Pro 8 database are:
John Smith
Mary Jones
Julie Hyde
Which three formulas can be used to extract the string "Mary Jones" (without quotes) from Contact? (Choose three.)
What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?
Click the Exhibit button.
You have a FileMaker Pro 8 layout based on the table occurrence Classes and you have a portal showing records from the table occurrence Students.
If you place the field Teachers::Name into the portal, the result is _____.
Which two statements are true about the [Guest] account that is included by default when creating a new FileMaker Pro 8 database? (Choose two.)
Given a FileMaker Pro 8 database with this script:
Perform Find [Restore]
#Find restores criteria: Customer::City: [XXXX]
Refresh Window
If [Get ( LastError )]
Show Custom Dialog ["No records found"; "No records matched your find criteria."]
End If
Which two statements are true if there are no records where the Customer::City field contains "XXXX"? (Choose two.)
Which three occur if the hard disk runs out of space during a "live" backup of files hosted on FileMaker Server 8? (Choose three.)
Given the following function:
Let ([ name = "William Henry Smith" ;
len = Length (name) ;
lastSpace = Position (name ; " " ; len ; -1)] ;
Right (name ; len - lastSpace)
)
Which value will be returned?
A FileMaker Pro 8 database has three separate windows open, each with its own found set and sort order. If a new window is opened, what will the new window inherit from the previously active window?
Given the following formula:
Date (
Month ( Get ( CurrentDate ) ) + 1;
1;
Year ( Get ( CurrentDate ) )
) - 1
What is the result?
Click the Exhibit button.
You have a FileMaker Pro 8 layout based on the table occurrence Teachers. You have a portal showing records from the table occurrence Students.
What happens if you place the field Classes::Class Name into the portal?
Given a FileMaker Pro 8 database containing these two scripts::
Script A:
Perform Script ["Script B" ; Parameter: 3]
Show Custom Dialog [Get (ScriptResult)]
Script B:
Set Variable [$x; Value:Get (ScriptParameter)]
Loop
Set Variable [$result ; Value: $result + $x]
Set Variable [$x ; Value: $x - 1]
Exit Loop If [$x = 0]
End Loop
Exit Script [Result: $result]
If a user runs Script A, what value will be displayed in the custom dialog?
What must be done to use the Allow FileMaker Pro clients to download updates automatically feature of FileMaker Server 8? (Choose three.)
Which two statements are true about script parameters in FileMaker Pro 8? (Choose two.)
Which two are required for a plug-in to be used with Web Published databases? (Choose two.)
What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)
Which two statements are true about the [Full Access] privilege set? (Choose two.)
Which three are capabilities of the Save Records as PDF [ ] script step? (Choose three.)
Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)
What is the result of the following formula?
Substitute("Abcd"; ["a";"b"];["b";"a"];["c";"d"];["d";"c"])
Consider two files, Alpha and Beta, where tables from Beta are included in the Relationships Graph of Alpha as external table occurrences. What are two ways to rename Beta while preserving all functionality in Alpha? (Choose two.)
Click the Exhibit button.
You have a FileMaker Pro 8 layout based on the table occurrence of Classes. You have a portal showing records from the table occurrence Students.
What happens if you place the field Students::Name into the portal?
Consider a FileMaker Pro 8 database with the following tables and fields:
Customer: customer_id, first_name, last_name
Order: order_id, customer_id, order_date
Product_Orders: order_id, product_id, quantity_ordered
Product: product_id, product_name, unit_price
Using only Cartesian cross-product ("x") relationships between table occurrences, sorting if necessary, which two actions can be performed? (Choose two.)
Which three statements are true about field indexing in FileMaker Pro 8? (Choose three.)
A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
Given a table, Table A in File A; which permissions allow access to data in Table A from another file, File B?
Which type of file results from converting a CDML format file using the FileMaker CDML Converter?
Consider a FileMaker Pro 8 database hosted by FileMaker Server 8. Two users, A and B, are accessing the database at the same time, and both are viewing records with the same layout. User A runs a script that loops through a found set, changing data in each record. Which statement is true?
TESTED 16 Oct 2025