Given two tables in FileMaker Pro 12 with the following fields and table occurrences:

What two methods can be used to add a portal to a layout based on the Players table, which shows only the names of the current player's teammates, but not the current player's name? (Choose two.)

• A. basesthe portal on the multi-predicate relationship: Players::TeamID = Teammates::TeamID AND Players: PlayerIDTeammates:: PlayerID
• B. base the portal on the relationship Players::TeamID = Teammates::TeamID Seta sort order of PlayerID. Ascending on the relationship, and Configurethe portal to have an Initial row value of 2.
• C. base the portal on the relationship Players:: TeamID = Teammates:: TeamID Anduse a portal filter based on the calculation Players:: PlayerIDTeammates:: PlayerID
• D. base the portal on the relationship Players:: Team ID = Teammates:: Team ID Anduse a portal filter based on the calculation Players:: PlayerIDSelf

Which two statements are true about the [Full Access] privilege set in a FileMaker Pro 12 database? (Choose two.)

• A. It is the only privilege set that can use Custom Functions.
• B. It can be deleted only if another full access privilege set has been created.
• C. It is the only privilege set that can modify field options in Table View.
• D. It is the only privilege set that can view the Relationships Graph.

A FileMaker Pro 12 database is hosted by FileMaker Server 12. User A and User B are accessing the database at the same time. User A runs a script that loops over a set of records and makes changes to those records. During the time that the script runs, User B is editing one of the records that is also in User A's found set and is being acted on by User As script.
Which statement is true about this situation?

• A. User As script will stop looping when it reaches the record User B is editing.
• B. When it reaches the record User B is editing, User As script will stop if User A's script is running with Set Error Capture [On]. Otherwise User A will be prompted to either continue
  or cancel the running script.
• C. User A's script will stop looping when it reaches the record User B is editing, and will wait to continue until User B releases the record.
• D. User A's script will make changes to all records in its found set except the record being edited by User B

The following script is run from a record on a layout based on a table occurrence that is not related to the Product table occurrence:
Go to Related Record [Show only related records; Match found set; From table: "Product"; Using layout: "Product" (Product)] Delete All Records [No dialog]
What happens after the script is run?

• A. All records in the current found set for the Product table are deleted.
• B. All records in the current table are deleted.
• C. All records in the current found set are deleted.
• D. All records in the Product table are deleted.

Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?

• A. Int(Month(myDate)/ 3)
• B. Ceiling(Month(myDate)/ 3)
• C. Let(m = Month(myDate);
  Case(m > 0 ; 1 ; m > 3 ; 2 ; m > 6 ; 3 ; 4)
  )
• D. Mod(Month(myDate); 3)+ 1
• E. Let(m = Month(myDate);
  Choose(m ; 1 ; 1 ; 1 ; 2 ; 2 ; 2 ; 3 ; 3 ; 3 ; 4 ; 4 ; 4) )