试题详情
- 多项选择题 Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(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 aboveSQL statement? （）
A、SER_NO
B、ORDER_ID
C、STATUS
D、PROD_ID
E、ORD_TOTAL
F、Composite index on ORDER_ID and ORDER_DATE
关注下方微信公众号，在线模考后查看
热门试题
- Which one is a syste
- Which four are corre
- You want to display
- ClicktheExhibitbutto
- Which statement crea
- What is true regardi
- Which two statements
- ExaminethedataintheE
- Which clause should
- In a SELECT statemen
- Examine the descrip
- Which two tasks can
- Evaluate the SQL st
- Which two are true a
- Which substitution v
- Examine the data in
- In a SELECT statemen
- Which is an /SQL*Plu
- The EMPLOYEES table
- Which constraint can