Which two statements are true regarding a SAVEPOINT? (Choose two.)

Which three statements are true about the DESCRIBE command?

Which statement is true about TRUNCATEand DELETE?

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session?
Which query can be used?

Examine the structure of the ORDERS table:

You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result? (Choose the best answer.)