A FileMaker Pro 11 file contains the following script: Show All Records Unsort Records Set Variable [$counter Get(FoundCount)] Go To Record/Request/Page [First] Loop Duplicate Record/Request Go To Record/Request/Page [First] Omit Record Set Variable [$counter Value: $counter 1] Exit Loop If [$counter=0] End Loop How many records will the table contain after this script is done executing, if the script begins execution in
a database table containing six records total?
A. 6
B. 12
C. 13
D. 24
E. The script will not finish executing but will loop until forcibly terminated.
Which statement is true about script parameters in FileMaker Pro 11?
A. Script parameters can include any number of repetitions.
B. A subscript inherits the script parameter of the script that called it.
C. Scripts set to run OnFirstWindowOpen cannot include script parameters.
D. When choosing scripts from the Scripts menu, script parameters can be added by holding down the Option (Mac OS X) or Alt (Windows) key.
E. Get( ScriptParameter ) results in a returndelimited list of script parameters for all currently running scripts in a window's script stack.
A FileMaker Pro 11 file contains the following script:
Set Variable [$counter Value:1]
Go To Record/Request/Page [First]
Loop
Go To Record/Request/Page [Next]
Exit Loop If [$counter > Get(RecordNumber)]
Set Variable [$counter Value: $counter + 1]
End Loop
#
Exit Script [Result: $counter]
If this script is executed in a context where there is found a set of six records, which value will be returned
from the script?
A. 1
B. 6
C. 7
D. 8
E. No value will be returned.
Given the following script:
Show Custom Dialog ["Please select either Black, Red, or Pink"]
# assume default button Black, second button Red, and third button Pink
If [ Get (LastMessageChoice) = 1 ]
Exit Script [Result: "You selected Black!" ]
Else If [ Get (LastMessageChoice) = "Red"]
Show Custom Dialog [ "You selected Red!" ]
Else
Show Custom Dialog [ "You selected Pink!" ]
End If
Show Custom Dialog ["You are done!"]
Which conclusion can be made?
A. Every user will see at least two dialogs.
B. Every user will see the "You are done!" dialog.
C. Users will never see the "You selected Red!" dialog.
D. The user will see "You selected Black!" if they click the default button.
Given the following function:
Let ( [
name = "Rufus, Wainright, Smithers, Ltd., Inc."
x = MiddleWords ( name 2 3 )
y = WordCount ( name )
]
Right ( x y )
)
What is returned?
A. , Ltd
B. Ltd.,
C. hers,
D. thers
E. Wainr
Given the following formula:
Case ( Score > 200 "Below Average"
Score > 400 "Average"
Score > 600 "Above Average"
Score)
Assuming the value of Score is 800, what is the result?
A. Below Average
B. Average
C. Above Average
D. 800
Given the following two calculation fields, Time1 and Time2:
Time1 (Calculation, Time result) = Time ( 5 10 15 )
Time2 (Calculation, Time result) = Time1 + 60
What is the value of Time2?
A. 5:10:75
B. 18675
C. 5:11:15
D. 6:10:15
E. 65:10:15
Given the following function: Position ( "Bobby Bubbles" "B" 2 2 ) What is returned?
A. 0
B. 3
C. 4
D. 7
Given the following function:
Substitute ( myText ["abc" "XYZ"] [ "XYZ" "abc"] )
if the field myText contains "abcxyz", what is the result?
A. abcabc
B. abcxyz
C. XYZabc
D. XYZxyz
Given a custom function created in FileMaker Pro 11 Advanced called Explode with a single parameter str
defined as:
Case ( Length ( str ) > 1
Explode ( Left ( str Length ( str ) 1
) )
and "?" and
Left ( str Length ( str ) 1
)
str )
What is the result of Explode ( "Bob" )?
A. Bo B
B. B Bo
B
C. B B Bo
D. Bob B Bo
E. B Bo Bob
F. Bob Bo B
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only FileMaker exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your FM0-305 exam preparations and FileMaker certification application, do not hesitate to visit our Vcedump.com to find your solutions here.