Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What happens when the following query is executed to process customers' requests to be forgotten?
DELETE FROM customers WHERE customer_id IN (SELECT customer_id FROM delete_requests)
A
The identified records will be removed from the customers table, and their associated data files will be permanently deleted from the table directory.
B
The identified records will be removed from both the customers and delete_requests tables, and their associated data files will be permanently deleted from the tables' directories.
C
The identified records will be removed from the customers table, but they will remain accessible in the table history until a VACUUM command is executed.
D
The identified records will be removed from both the customers and delete_requests tables, but they will remain accessible in the table history until VACUUM commands are executed.
E
The identified records will be removed from the customers table, but they will remain accessible in the table history until the status of the requests in the delete_requests table is updated.
