nerdexam
FileMaker

FM0-307 · Question #84

A new database is created with two tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related…

The correct answer is C. The formula in the calculation field Name Full (defined as Name First & " " & Name Last). See the full explanation below for the reasoning.

Question

A new database is created with two tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted. What happens when the Client table occurrence is deleted from the Relationships Graph?

Options

  • ASince it is the only occurrence of the Client table on the graph, it can not be deleted.
  • BAny records in the Contracts table that were related to matching Client records are
  • CThe formula in the calculation field Name Full (defined as Name First & " " & Name Last)
  • DAny records in the Contracts table that were related to matching Client records will have

How the community answered

(51 responses)
  • A
    8% (4)
  • B
    2% (1)
  • C
    84% (43)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full FM0-307 Practice