dumpspedia logo
Click the Exhibit button.
You have two fields, Pointer and Product. Each field is defined to have three repetitions, and the data shown in the exhibit.
What is the result of the following formula?
Let(
[
$i[1] = Pointer[1];
$i[2] = Pointer[2];
$i[3] = Pointer[3];
$result[$i[2]] = Product[$i+1]
];
$result
)
A user attempts to log in to a database hosted on FileMaker Server 8. It is set up to allow authentication via FileMaker and External Server accounts. The user is a member of two external groups that have been set up in the Edit Account dialog to be authenticated using an external server. Assuming a valid username and password, with which matching account will the user authenticate?
When importing table schema and data using FileMaker Pro 8 Advanced, which two statements are true? (Choose two.)
In the Fields tab of the Define Database dialog in FileMaker Pro 8, which two are valid field types? (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?
Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)
While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:
Show All Records
Go to Record/Request/Page [First]
Loop
If [Customer::Category <> "A"}
Omit Record
Else
Go to Record/Request/Page [Next; Exit after last]
End If
Exit Loop If [Get ( FoundCount )= 0]]
End Loop
After the script stops running, which two statements are true? (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.)
What are two reasons you might use the Let function within a calculation formula in a FileMaker Pro 8 database field? (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.)
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?
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?
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.)
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?
Which three statements are true about field indexing in FileMaker Pro 8? (Choose three.)
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.)
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 )?
Which three Web Publishing options are available in FileMaker 8? (Choose three.)
Given a stored calculation field modifiedBy that contains the following formula:
Evaluate ( Quote ("Modifiedby: " & Get (AccountName)) ; myField)
Which two statements are true? (Choose two.)
What is the result of the following formula?
Substitute("Abcd"; ["a";"b"];["b";"a"];["c";"d"];["d";"c"])
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 Task button.
Place each specification next to its definition for FileMaker Server 8 Advanced (Windows OS).
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?
Click the Exhibit button.
You run the following script from a layout assigned to the table occurrence Teachers:
Go to Related Record [Show only related records; From table: "Enrollment";
Using layout: "Enrollment" (Enrollment)]
Assuming there are matching records in all tables, what is the found set when the script completes?
What must be done to use the Allow FileMaker Pro clients to download updates automatically feature of FileMaker Server 8? (Choose three.)
Given the formula:
Filter ( "Computer Science 201"; "0123456789" )
What is the result?
Which three technologies/products may be used in conjunction with FileMaker Server 8 Advanced to produce custom Web pages? (Choose three.)
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?
TESTED 19 May 2024
