View the Exhibit and examine the description of the tables
You execute this SQL statement
INSERT INTO sales VALUES(23,2300,SYSDATE,(SELECT channel_id FROM channels
WHERE channel_desc = 'Direct Sales'),12,1,500);
Which three statements are true?
A.The sales table has five foreign keys B.The statement will execute successfully and a new row will be inserted into the SALES table C.A product can have a different unit price at different times D.A customer can exist in many countries. E.The statement will fail if a row already exists in the SALES table for product 23 F.The statement will fail because a subquery may not be contained in a VALUES clause正确答案ABD
