Which of the following functions can be used to determine how many months past since a book has been published?

Question $1$ options:

MONTH

MON

MONTHS$\_$BETWEEN

none of above

Question $2(2\mathrm{.}5$ points$)$

Listen

UPPER function can be used in WHERE clause to match any capital values

Question $2$ options:

True

False

Question $3(2\mathrm{.}5$ points$)$

Listen

Which of the following SQL statements produces "Welcome To Class" as the output?

Question $3$ options:

SELECT "Welcome To Class" FROM dual;

SELECT INITCAP$(\text{'}$WELCOME TO CLASS'$)$ FROM dual;

SELECT LOWER$(\text{'}$WELCOME TO CLASS'$)$ FROM dual;

both a and b

none of above

Question $4(2\mathrm{.}5$ points$)$

Listen

NVL and NVL$2$ functions are both same.

Question $4$ options:

True

False

Question $5(2\mathrm{.}5$ points$)$

Listen

Which of the following determines how long ago orders that haven't shipped were

received?

Question $5$ options:

SELECT order#$,$ shipdate$-$orderdate delay

FROM orders;

SELECT order#$,$ SYSDATE $-$ orderdate

FROM orders

WHERE shipdate IS NULL;

SELECT order#$,$ NVL$($shipdate$,0)$

FROM orders

WHERE orderdate is NULL;

SELECT order#$,$ NULL$($shipdate$)$

FROM orders;

Question $6(2\mathrm{.}5$ points$)$

Listen

Single Row functions can work on several records at a time.

Question $6$ options:

True

False

Question $7(2\mathrm{.}5$ points$)$

Listen

Which of the following functions can produce different results, depending on the value of a specified column? This function behaves same as IF THEN clause in programming

Question $7$ options:

NVL

DECODE

UPPER

SUBSTR