nerdexam
FileMaker

FM0-308 · Question #36

FM0-308 Question #36: Real Exam Question with Answer & Explanation

The correct answer is B. Employee has 2 records. Asset has 15 records. See the full explanation below for the reasoning.

Question

Given a solution hosted on FileMaker Server 13 with tables Employee and Asset. Employee and Asset are related (one to many) based on an Employee ID field with no cascading delete rule. There is one layout associated with each table as well as the following scripts. There are 5 records in Employee {Andrew;Bob;Cara;David;Edward}. Each employee has exactly 3 related Asset records, for 15 total assets. A user opens the database and navigates to the fifth record {Edward}, then runs the script Remove Employee Assets. What will be true after the script completes running?

Exhibit

FM0-308 question #36 exhibit

Options

  • AEmployee has 2 records. Asset has 15 records.
  • BEmployee has 2 records. Asset has 15 records
  • CEmployee has 5 records. Asset has 12 records.
  • DEmployee has 5 records. Asset has 12 records.
  • EEmployee has 5 records. Asset has 15 records.

Community Discussion

No community discussion yet for this question.

Full FM0-308 Practice