Spring Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65
marks4sure logo
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 field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
For FileMaker Pro 8 files that are opened (i.e. to resolve a relationship) and where the window remains hidden, which statement is true about a script set to perform When opening this file?
Click the Exhibit button.
What changes need to be made to the database to create a portal on a layout tied to the Customer table occurrence that displays all products (without duplication) that a customer has ever ordered?
Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)
On conversion to FileMaker Pro 8, what does the old password from FileMaker Pro 6 become?
Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)
In FileMaker Pro 8, which two can reference unrelated table occurrences? (Choose two.)
Which two privileges are needed for a non [Full Access] privilege set to allow the creation and modification of new layouts in a FileMaker Pro 8 database? (Choose two.)
Which three are valid types listed in the FileMaker Pro 8 Export Records to File dialog? (Choose three.)
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?
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?
Which three are required to get XML data, using a Web browser, from a database hosted by FileMaker Server 8 Advanced? (Choose three.)
Which two settings affect an Account that is authenticated via FileMaker but not an Account that is authenticated via an External Server? (Choose two.)
You are using FileMaker Pro 8 Advanced and planning a Contacts database. Others will be able to modify field definitions after you finish the creation of the database. You are considering using a custom function available on a public website to help in formatting phone numbers. What are three reasons to use custom functions in this situation? (Choose three.)
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?
In FileMaker Pro 8, what are three things you can do using the script steps for managing accounts? (Choose three.)
A Past Due script finds all customer records with past due invoices. Which script step needs to precede the Perform Find [ ] script step to ensure the script works properly?
Consider two FileMaker Pro 8 files, Alpha and Beta, where a table from Beta appears as an externally referenced table occurrence on Alpha's Relationships Graph. Which three statements are true? (Choose three.)
Which two statements are true about script parameters in FileMaker Pro 8? (Choose two.)
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 about a person can display the name of the current person's manager as well as a portal of the people managed by the current person (as shown in the exhibit).
Assume that there are no lookup fields or calculation fields defined in any table, and there are no scripts in the file.
What is the minimum number of table occurrences you must use to construct the layout?
Which three are capabilities of the Save Records as PDF [ ] script step? (Choose three.)
Given the formula:
Choose( Qty / 100; 0; 2; 4; 6; 8 )
If the field Qty contains the value 250, what is the result?
Click the Exhibit button.
Given the FileMaker Pro 8 relationship graph shown in the exhibit, a layout assigned to the Teachers table occurrence has fields Name and Address, and a portal showing the Students table occurrence.
If a developer assigns the layout to the Advisors table occurrence, what happens to the data displayed?
What must be done to use the Allow FileMaker Pro clients to download updates automatically feature of FileMaker Server 8? (Choose three.)
Which three script steps in a FileMaker Pro 8 database may fail if another user is editing the record on which the script is operating? (Choose three.)
Given the formula:
Filter ( "Computer Science 201"; "0123456789" )
What is the result?
When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)
Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)
Which two must be configured for a Web Publishing Engine to interact with a specific FileMaker server? (Choose two.)
Given a custom function created in FileMaker Pro 8 Advanced called "MyFunction" with a single parameter "Number" defined as:
If (
Number = 0 ;
Number ;
Number & ", " & MyFunction ( Number - 1 )
)
What is the result of MyFunction ( -3 )?
TESTED 02 May 2026