The SYSDATE function displays the current Oracle Server date as: 5/21/2019 You wish to display the date as: MONDAY, 21 MAY, 2019 Which statement will do this? A. SELECT TO_DATE(SYSDATE, ‘FMDAY, DD MONTH, YYYY’) FROM DUAL; B. SELECT TO_CHAR(SYSDATE, ‘FMDD,…
Examine the data in the PRODUCTS table: Examine these queries: Which queries generate the same output? A. 1 and 2 B. 1 and 3 C. 1, 2, and 3 D. 2 and 3
Examine the description of the EMPLOYEES table: Which two queries return rows for employees whose manager works in a different department? (Choose two.) A. B. C. D. E.
Examine the data in the EMPLOYEES table. Which statement will compute the total annual compensation for each employee? A. SELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * monthly_commission_pct) AS annual_comp FROM employees; B. SELECT last_name, (monthly_salary + monthly_commission_pct)…
Examine the description of the ORDER_ITEMS table: Examine this incomplete query: Which two can replace <clause> so the query completes successfully? (Choose two.) A. quantity, unit_price B. quantity * unit_price C. quantity D. total_paid E. product_id
Examine the description of the EMPLOYEES table: Examine this query: Which line produces an error? A. Line 5 B. Line 8 C. Line 7 D. Line 3
Which two are true about savepoints? (Choose two.) A. After issuing a savepoints, you can roll back to the savepoint name within the current transaction. B. A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in…
Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: Statement 2: Which two statements are true? (Choose two.) A. Statement 2 may return multiple rows of output. B. Both statements will…
The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.) A. WHERE TO_CHAR(order_date, ‘MON DD YYYY’) =…
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 DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM…