Question 290
A data professional makes this decision: Use an INSERT statement specifying the new product values. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for INSERT row: A new row is created without replacing the table's existing rows.
Incorrect Answers
This result would follow the different First normal form decision (Replace repeating product lists with atomic values represented in related rows.) rather than the specified design.
This result would follow the different LEFT JOIN decision (Use a LEFT OUTER JOIN from customers to orders.) rather than the specified design.
This result would follow the different Stored procedure decision (Create a stored procedure encapsulating the routine.) rather than the specified design.