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?

Question

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?

Accepted Answer

A. a WHILE loop that contains a single DELETE statement

Answer

B. multiple TRUNCATE TABLE statements

Answer

C. a single transaction that contains multiple DELETE statements

Answer

D. an IF statement that contains a single DELETE statement

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…

Question

Options

How the community answered

Community Discussion