一、原题 Examine the structure of the PROMOS table: Name Null Type PROMO_ID NOT NULL NUMBER(3) PROMO_NAME VARCHAR2(30) PROMO_START_DATE NOT NULL DATE PROMO_…
一、原题 Examine the structure of the TRANSACTIONS table:) Name Null Type TRANS_ID NOT NULL NUMBER(3) CUST_NAME VARCHAR2(30) TRANS_DATE TIMESTAMP TRANS_AMT …
一、原题 Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table: LIST_PRICE MIN_PRICE 10000 8000 20000 30000 30000 Which two expressions give the same output? (Choose two.) A. NVL(NULLIF(list_price, min_price)…
一、原题 Which statement is true regarding the COALESCE function? A. It can have a maximum of five expressions in a list. B. It returns the highest NOT NULL value in the list for all rows. C. It requires that all expressions in the list must be of the sa…