Question 300
A data architect recommends this approach: Use DELETE with a WHERE predicate matching expired sessions. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for DELETE selected. Matching rows are removed while other records remain.
Incorrect Answers
The other situation is better matched to Add a WHERE condition on invoice due date. Rows not satisfying the filter are excluded before aggregation.
The other situation is better matched to Move the transitive lookup attributes into a separate reference table. Non-key attributes are less likely to introduce transitive update anomalies.
The other situation is better matched to Use an appropriate fixed-precision decimal type for monetary columns. Stored values can represent defined decimal precision for financial calculations.