Candace saved her query for her time cards. after running the query once, she found two more pay slips and added them to the original data table. which best describes what will happen? she will be prompted with an error message saying she cannot modify queries multiple times. the data will not show up in the new query and will need to be resaved. she will need to design a new query that includes her new numbers. when the query is run again, the data that meets the new criteria will be retrieved.

Rollback or rewrite the query for the data table.

Explanation:

Method 1:-

Candace has to roll back the data table update if possible. As best practice before update the data table better to take the backup of the data table. So that drops the updated data table and restores from the backup table.  

Modify query by add two payslip in the query and rerun the query

Method 2:-

Before committing the rollback the complete process and two payslips in queries (which is missing records) and rerun the query.

Method 3: -

1.Complete re-engineering the update query.

2.Then add two payslips (missing records)

3.Rerun  the query