nerdexam
Microsoft

MB6-704 · Question #51

You have two tables named CustTable and CustGroup. Each record in CustTable references a record in CustGroup. You need to create a delete action to ensure that the records in CustGroup can be…

The correct answer is B. On CustGroup, create a Restricted delete action for CustTable. Delete Action: Restricted Restricts deletion in the current table if data is present in related tables. Setting the DeleteAction property to Restricted extends the functionality of the table's validat- As a result, super(), in validateDelete, checks whether records exist on…

Develop Application Objects

Question

You have two tables named CustTable and CustGroup. Each record in CustTable references a record in CustGroup. You need to create a delete action to ensure that the records in CustGroup can be deleted only if there are no records in CustTable that reference the record in CustGroup. What should you do?

Options

  • AOn CustGroup, create a Cascade delete action for CustTable.
  • BOn CustGroup, create a Restricted delete action for CustTable.
  • COn CustTable, create a Restricted delete action for CustGroup.
  • DOn CustTable, create a Cascade delete action for CustGroup.

How the community answered

(21 responses)
  • A
    10% (2)
  • B
    71% (15)
  • C
    14% (3)
  • D
    5% (1)

Explanation

Delete Action: Restricted Restricts deletion in the current table if data is present in related tables. Setting the DeleteAction property to Restricted extends the functionality of the table's validat- As a result, super(), in validateDelete, checks whether records exist on related tables. If records do exist, validateDelete returns false. The forms system ensures that the deletion is not per- formed. In your own X+ + code, check the return value of validateDelete. Don't delete the pri- mary or related records if the method returns false. On the CustTable table, a restricted delete action has been defined for the CustTrans table. When a customer is deleted in the CustTable table, the validateDelete method ascertains whether trans- actions exist for the customer in the CustTrans table. If so, validateDelete returns

Topics

#delete actions#Restricted delete#table relationships#referential integrity

Community Discussion

No community discussion yet for this question.

Full MB6-704 Practice