A.after
B.when
C.if
D.unless
第1题:
A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESC
B.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limit
C.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLAST
D.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST
第2题:
第3题:
No credit will be offered()you place an order for more than 40.000 units.
A after
B when
C if
D unless
第4题:
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
第5题: