View the Exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.) A. SELECT AVG(inv_date )FROM invoice; B. SELECT MAX(inv_date),MIN(cust_id)FROM invoice; C. SELECT MAX(AVG(SYSDATE - inv_date))FROM invoice; D. SELECT AVG(…
Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table: Which two expressions give the same output? (Choose two.) A. NVL(NULLIF(list_price, min_price), 0) B. NVL(COALESCE(list_price, min_price), 0) C. NVL2(COALESCE(list_price, min_price), min_price, 0) D. COALESCE(NVL2(list_price, list_price, min_price), 0)
Examine the structure of the PROMOS table: You want to display the list of promo names with the message ‘Same Day’ for promos that started and ended on the same day. Which query gives the correct output? A. SELECT promo_name,…
Examine the structure of the PROMOS table: You want to generate a report showing promo names and their duration (number of days). If the PROMO_END_DATE has not been entered, the message ‘ONGOING’ should be displayed. Which queries give the correct…
Examine the structure of the TRANSACTIONS table: Name Null Type TRANS_ID NOT NULL NUMBER(3) CUST_NAME VARCHAR2(30) TRANS_DATE DATE TRANS_AMT NUMBER(10,2) You want to display the transaction date and specify whether it is a weekday or weekend. Evaluate the following two…
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 NUMBER(10,2) You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The…
Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table: PROMO_BEGIN _DATE ------------------------------------ 04-jan-00 10-jan-00 15-dec-99 18-oct-98 22-aug-99 You want to display the number of promotions started in 1999 and 2000. Which query gives the correct output? A. SELECT…
View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format. Which two queries give the correct result? (Choose two.) A. SELECT promo_name, TO_CHAR(promo_end_date,’Day’) ‘, ‘TO_CHAR(promo_end_date,’Month’) ‘ ‘TO_CHAR(promo_end_date,’DD, YYYY’)…
Examine the structure and data in the PRICE_LIST table: Name Null Type ---------------------- PROD_ID NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD_PRICE ---------------------- 100 $234.55 101 $6,509.75 102 $1,234 You plan to give a discount of 25% on the product price…
You want to display the date for the first Monday of the next month and issue the following command: SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’), ‘dd "is the first Monday for"fmmonth rrrr’) FROM DUAL; What is the outcome? A. It executes successfully and returns…