|
#154. 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 above SQL statement? (Choose two)
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.066
Forum
Master braindump