OCP-1Z0-051 第113题 GROUP BY, TO_CHAR的应用

一、原题

Examine the structure of the ORDERS table:
Name                Null                Type
ORDER_ID           NOT NULL           NUMBER(12)
ORDER_DATE         NOT NULL           TIMESTAMP(6)
CUSTOMER_ID        NOT NULL           NUMBER(6)
ORDER_STATUS                          NUMBER(2)
ORDER_TOTAL                           NUMBER(8,2)
You want to find the total value of all the orders for each year and issue the following 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 outcome?
A. It executes successfully and gives the correct output.
B. It gives an error because the TO_CHAR function is not valid.
C. It e