试题详情
- 多项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Which object privile
- Which two statements
- 用二维表结构表达实体集的模型是（）。
- Before a Flashback
- You are
- In your p
- Evaluate the&e
- When executing a SQL
- Which statemen
- For which two situat
- ClicktheExhibitbutto
- Click the
- The ORACLE_SID envi
- Examine the descrip
- Examine the&en
- Which of
- Youexecutedthefollow
- Consider the&#
- You want to set the
- After implementing