多项选择题
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
单项选择题 Which object privileges can be granted on a view?（）
单项选择题 Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单项选择题 What is true about sequences?（）
