Question

Which of the following is NOT true about editing, adding, and deleting records?

1) Records can be deleted from a single table without additional steps if the table is not part of a relationship.
2) When you add a record to a form, you are actually adding the record to the table it will be stored in.
3) Changes to data are saved automatically.
4) If the table is part of a relationship, referential integrity has been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.

Answer 1

The incorrect statement is the fourth option. When referential integrity is enforced and cascade delete is enabled, deleting a record in a primary table will automatically delete the related records in a related table, contrary to the statement.

Step-by-step explanation:

The statement that is NOT true about editing, adding, and deleting records is the fourth option. When referential integrity is enforced in a database and the cascade delete option is turned on, deleting a record from a primary table will also delete related records from a related table. Thus, it is not necessary to manually delete related records in another table - the cascade delete option automates this process.

Addressing the other options: 1) It is true that records can be deleted from single tables without additional steps if no relationships exist. 2) Adding a record through a form does indeed add the record to the underlying table. 3) Changes to data may not always be saved automatically; this depends on the database system and settings being used.