Q107 View the Exhibit and examine the description of the tables

Q107 View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true?

• (A). The statement will fall if a row already exists in the sales table for product 23.
• (B). The sales table has five foreign keys.
• (C). A product can have a different unit price at different times.
• (D). A customer can exist in many countries.
• (E). The statement will execute successfully and a new row will be inserted into the sales table.
• (F). The statement will fail because a subquery may not be contained in a values clause.