试题详情
- 多项选择题 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
- A,F
关注下方微信公众号，在线模考后查看
热门试题
- Consider the&e
- Which three are DATE
- （）是Oracle服务器在启动期间用来标
- Exhibit One the
- Which method would y
- Which of
- Which four actions a
- Exhibit： View&e
- The transporta
- All the d
- Which initiali
- A media
- Oracle管理数据库存储空间的最小数据
- You are
- Which two statements
- Mary has a view call
- What is true regardi
- You wish to enable
- Which three elements
- You need