A layout contains a portal that allows creation of related records. What are two techniques that can be used to navigate to the empty row at the bottom of the portal? (Choose two.)
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
)
Given the formula:
Filter ( "Computer Science 201"; "0123456789" )
What is the result?
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 use of encryption in FileMaker 8? (Choose two.)
Which two settings affect an Account that is authenticated via FileMaker but not an Account that is authenticated via an External Server? (Choose two.)
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 _____.
Which two statements are true for an account in a FileMaker Pro 8 database that is authenticated externally? (Choose two.)
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.)
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.)
What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)
Which two statements are true about sorted portals in FileMaker Pro 8? (Choose two.)
Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)
In FileMaker Pro 8, which two statements are true for layout setup options? (Choose two.)