Question 270
A data professional makes this decision: Use a SELECT statement projecting the required columns. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for SELECT columns: The query reads selected fields and leaves stored rows unchanged.
Incorrect Answers
This result would follow the different Third normal form decision (Move the transitive lookup attributes into a separate reference table.) rather than the specified design.
This result would follow the different Transaction rollback decision (Roll back the uncommitted transaction rather than committing its partial changes.) rather than the specified design.
This result would follow the different UPDATE row decision (Use UPDATE with a WHERE clause targeting the supplier key.) rather than the specified design.