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…

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…

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…

View the Exhibit and examine the structure and data in the INVOICE table. Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.) A. inv_amt =’0255982′ : requires explicit conversion B. inv_date >…

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME -——————– Lex De Haan Renske Ladwig Jose Manuel Urman Jason Mallin You want to extract only those customer names that have three names and display the * symbol…

View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values ‘Anderson’ and ‘Ausson’. You issue the following query: SQL> SELECT LOWER(REPLACE(TRIM(‘son’ FROM cust_last_name), ‘An’, ‘O’)) FROM CUSTOMERS WHERE LOWER(cust_last_name)…

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.) A. finding the remainder of a division B. adding a number to a date for a resultant date value C. comparing two expressions to…

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table. Evaluate the following two queries: SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code" FROM promotions ORDER BY code; SQL>SELECT DISTINCT promo_category promo_cost "code" FROM promotions ORDER BY…