Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city = `D_%’; B. SELECT * FROM customers WHERE city LIKE `D_%’; C. SELECT * FROM customers WHERE city… Read More »
View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks require subqueries? (Choose two.) A. Display the total number of products supplied by supplier 102 which have a product status of obsolete B. Display the minimum PROD_LIST_PRICE for each product status C. Display suppliers whose PROD_LIST_PRICE is less than 1000 D. Display the number of… Read More »
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions? (Choose two.) A. qty_sold BETWEEN ‘101’ AND ‘110’ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. invoie_date >… Read More »
Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city LIKE ‘D_’; B. SELECT * FROM customers WHERE city = ‘%D_’; C. SELECT * FROM customers WHERE city… Read More »
Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.) A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1; B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2; C. SELECT DISTINCT promo_cost || ‘ in ‘ || DISTINCT promo_category FROM promotions ORDER… Read More »
Examine the description of the SALES1 table:SALES2 is a table with the same description as SALES1.Some sales data is duplicated in both tables.You want to display the rows from the SALES1 table which are not present in the SALES2 table.Which set operator generates the required output? A. SUBTRACT B. UNION ALL C. INTERSECT D. MINUS E. UNION Correct… Read More »
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.Which two queries execute successfully? (Choose two.) A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available’)) FROM customers; B. SELECT NVL(cust_credit_limit * .15, `Not Available’) FROM customers; C. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; E. SELECT NVL2(cust_credit_limit *… Read More »
Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.) A. SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions; B. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions; C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions; D. SELECT… Read More »
Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <>… Read More »
Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city = ‘D_%’; B. SELECT * FROM customers WHERE city = ‘%D_’; C. SELECT * FROM customers WHERE city… Read More »