OCP CBT Question 503

Please solve the following question.

You have a `SALES` table with `SALE_ID` (NUMBER), `SALE_DATE_STR` (VARCHAR2(10) in 'YYYY-MM-DD' format), and `AMOUNT` (NUMBER). You need to calculate the total amount of sales for all sales that occurred on a weekend (Saturday or Sunday). Which combination of functions is most appropriate?

SALES Table Structure`sqlDESC SALES;Name Null? Type----------------- -------- -------------SALE_ID NOT NULL NUMBER(6)SALE_DATE_STR NOT NULL VARCHAR2(10)AMOUNT NUMBER(10,2)`

TO_DATE, TO_CHAR with 'D' format mask, and a CASE expression or WHERE clause.

TO_CHAR with 'DY' format mask and a WHERE clause.

TO_DATE, NVL, and a GROUP BY clause.

TO_NUMBER, DECODE, and an aggregate function.

SALES Table StructuresqlDESC SALES;Name Null? Type----------------- -------- -------------SALE_ID NOT NULL NUMBER(6)SALE_DATE_STR NOT NULL VARCHAR2(10)AMOUNT NUMBER(10,2)

SALES Table Structure`sqlDESC SALES;Name Null? Type----------------- -------- -------------SALE_ID NOT NULL NUMBER(6)SALE_DATE_STR NOT NULL VARCHAR2(10)AMOUNT NUMBER(10,2)`