试题详情
多项选择题 Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）

A、SER_NO

B、ORDER_ID

C、STATUS

D、PROD_ID

E、ORD_TOTAL

F、composite index on ORDER_ID and ORDER_DATE

  • A,F

  • 关注下方微信公众号，在线模考后查看

热门试题