使用如下的CREATE TABLE脚本(语句)创建一个名为PO_DETAIL的表。
CREATE TABLE po_detail
(po_num NUMBER NOT NULL,
po_line_id NUMBER NOT NULL,
product_id NUMBER NOT NULL,
quantity NUMBER(3)NOT NULL,
unit price NUMBER(5, 2)DEFAULT 0,
PRIMARY KEY (po_num, po_line_id),
FOREIGN KEY (po_num) REFERENCES PO_HEADER (po_num),
FOREIGN KEY (product_id) REFERENCES product (product_id),
CHECK (unit_price BETWEEN 0 and 9999.99))
TABLESPACE USERS;
其中，PO_HEADER和PO_DETAIL表的结构和表中的数据如下：
请问，在以下的INSERT语句中，哪两个将成功地执行
A．INSERT INTO po_detail (po_num, po_line_id, product_id, unit_price, quantity)
VALUES (’10056’, ’1’, ’3’, ’400’,’1052.40’);
B．INSERT INTO po_detail (po_num, po_line_id, product_id)
VALUES (10055, 1, 2);
C．INSERT INTO po_detail
VALUES (10055, 1, 2, 30, DEFAULT);
D．INSERT INTO po_detail (po_num, po_line_id, product_id, quantity, unit_price)
VALUES(10052, 2, 3, 200, NULL);
E．INSERT INTO po_detail
VALUES (10056, 1, 3, 400, 52.40);
F．INSERTINTO po_detail
VALUES (10055, 1, 2, NULL, NULL);
