The SYSDATEfunction displays the current Oracle Server date as:
21-MAY-19
You wish to display the date as:
MONDAY, 21 MAY, 2019
Which statement will do this?
SELECT TO_DATE(SYSDATE, 'FMDAY, DD MONTH, YYYY') FROM DUAL;

Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONS table,
you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

View the Exhibit and examine the structure of the PROMOTION table.
You have to generate a report that displays the promo named start data for all promos that started after that last promo in the 'INTTERNET' category.

You issue this command which succeeds:
SQL> DROP TABLE products;
Which three statements are true?