为自己加油

Examine the description of the SALES table
Name Null type
-----------------------------------------------------
PRODUCT_ID NOT NULL NUMBER(10)
CUSTOMER_ID NOT NULL NUMBER(10)
TIME_ID NOT NULL DATE
CHANNEL_ID NOT NULL NUMBER(5)
PROMO_ID NOT NULL NUMBER(5)
UANTITY_SOLD NOT NULL NUMBER(10,2)
PRICE NUMBER(10,2)
AMOUNT_SOLD NOT NULL NUMBER(10,2)
The SALES table has 55,000 rows
Examine this statement:
CREATE TABLE sales1(prod_id, cust_id, quantity_sold, price)
AS
SELECT PRODUCT_ID, CUSTOMER_ID, QUANTITY_SOLD, PRICE
FROM sales WHERE 1 = 1;

A.SALES1  has NOT NULL  constraints  on  any  selected  columns  which  had  those  constraints  in
The SAIES table
B.SALES1 is created with 55,000 rows
C.SALES1  has  PRIMARY  KEY  and  UNIQUE  constraints  on  any  selected  columns  which  had
Those constraints in the sales table