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.)
Answer : A,B,D
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.)
Answer : C,D,E
In FileMaker Pro 8 given a calculation field in the Items table named ItemPrice with the following formula:
Lookup (Products::Price)
Which statement is true?
Answer : B
What are two reasons you might use the Let function within a calculation formula in a
FileMaker Pro 8 database field? (Choose two.)
Answer : A,B
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 )?
Answer : A
Which three text functions are case sensitive? (Choose three.)
Answer : A,B,D
Given the following formula:
Date (
Month ( Get ( CurrentDate ) ) + 1;
1;
Year ( Get ( CurrentDate ) )
) - 1
What is the result?
Answer : C
Given the formula:
Choose( Qty / 100; 0; 2; 4; 6; 8 )
If the field Qty contains the value 250, what is the result?
Answer : C
Given the following formula:
Let ( myCalc = "6 * 3" ; Evaluate (myCalc))
Which value will be returned?
Answer : C
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?
Answer : A
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
Answer : C
What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?
Answer : B
What is the maximum number of files that can be hosted on FileMaker Server 8?
Answer : A
Which two statements are true about use of encryption in FileMaker 8? (Choose two.)
Answer : B,D
Given a new privilege set in a FileMaker Pro 8 database, which two extended privileges can be enabled to enable an external application to connect to the database? (Choose two.)
Answer : B,C