Your customer has asked you to create a report that shows all incidents opened within the past month.
The report should show the following columns:
• Number of incidents opened in the past month
• Number of incidents opened in the past week
• Number of incidents opened in the past day
Which two functions are needed in the expressions to create the three columns?
A.
NVL
B.
AVG
C.
IF
D.
DECODE
E.
SUM
Explanation:
Incorrect:
Not A: In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is
encountered.
Not D: DECODE compares expr to each search value one by one. If expr is equal to a search, then
Oracle Database returns the corresponding result. If no match is found, then Oracle returns default.
If default is omitted, then Oracle returns null.
OK