Which three statements are true regarding single-row functions? (Choose three.)
A.
They can return multiple values of more than one data type.
B.
They can be used in SELECT, WHERE, and ORDER BY clauses.
C.
They can accept a column name, expression, variable name, or a user-supplied constant
as arguments.
D.
They can accept only one argument.
E.
They can be nested up to only two levels.
F.
They can modify the data type of the argument that is referenced.
Can anyone provide the real answer, since answer says all are correct?
BCF
B, C & F
BCF
b := we can use it as (select upper(firstname) from emp where upper(ename) = ‘SAHIL’ order by round(salary))
c := as a argument they can use any one mention above
f := they can modify data type using data convertion function like to_date , to_char , to_number even though this can take implicitly in some cases but its a good practice to state it explicitly…