You have a database that has 20 tables. The tables are not configured to have any
referential integrity. All tables have primary keys. Each table contains over 5 million rows.
Ten percent of the rows contain outdated information. You need to design a maintenance
process to delete all outdated rows. The solution must meet the following requirements: •
Minimize execution time • Minimize development effort • Minimize blocking other processes
• Prevent deletion failures from affecting the entire deletion process What should the design
include?
A.
an IF statement that contains a single DELETE statement
B.
a single transaction that contains multiple DELETE statements
C.
a WHILE loop that contains a single DELETE statement
D.
multiple TRUNCATE TABLE statements