Which three statements are true about single-row functions? (Choose three.)
Which three statements are true about single-row functions? (Choose three.)
Single-row functions can take a column name, variable, literal, or expression as an argument. They can also return a different data type than the argument provided. These functions can be nested to any level, allowing for complex expressions.
Correct choice is B C D. single row function can be nested to any level.
D is not correct, more than three nested functions return ora0935
I had no such error in 11.2 select DECODE(COALESCE(NVL(ROUND(TRUNC(5)),4),3),2)1) from dual;
statement correction: select decode(coalesce(nvl(round(trunc(5)),4),3),5,5,1) from dual; -- or select decode(coalesce(nvl(round(trunc(5)),4),3),2,1) from dual;
Hi, it is posible . This pdf http://moko.lecturer.pens.ac.id/file/Basis%20Data%201/Les03%20-%20Using%20Single-Row%20Functions%20to%20Customize%20Output.pdf
B,C,D A - Incorrect -> Documentation: "can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVING clauses." B - Correct -> EXAMPLE: select lower(&data), lower(DUMMY), lower('TABLE'),LOWER(TO_DATE('12-JAN-08','DD-MONTH-RR')) from dual; RESULT: 12-jan-21 x table 12-jan-08 C - Correct -> Like in length or months_between D - Correct -> there's no limit in documentation. EXAMPLE: select instr(substr(decode(mod(6,4),4,'abcabcabc',1,'bcabcabca','cabcabcab'),4),'abc') from dual; RESULT: 2 E - Incorrect -> Functions like substr, accepts more than one parameter F - Incorrect -> Here's a catch, documentation: "Single-row functions return a single result row for every row of a queried table or view" NOT "...return a single result row per table"
Thank you for Clarifying F...
Thanks for showcasing the difference with respect to F..
B & C & D is correct answer
yes, D is also correct … see Question 30 > https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm
A - FALSE; can be used after SELECT, in WHERE clause, in START WITH clause, in CONNECT BY clause and in HAVING clause B - TRUE C - TRUE; typically conversion functions, e.g. TO_CHAR, TO_DATE D - TRUE E - FALSE; they can accept more arguments, e.g. TO_DATE('2023-09-19 16:15','YYYY-MM-DD HH24:MI') F - FALSE; group functions return a single result per group, while single-row functions returns a result for each input value
B C D & E seems right to me :\ I guess.. D is the most close to wrong, since i'm sure there's some kind of nesting limit, but this limit is not specified in oracle documentation.
There is no such limit for single-row functions, and E is certainly false: for instance, CONCAT is a single-row function and it accepts two arguments.
Correct one B, C, F
This is note regards single row function and aggregate function https://oracledbars.blogspot.com/2018/01/using-conversion-functions-and.html. Nesting Functions Single-row functions can be nested to any level. • Nested functions are evaluated from the deepest level to the least deep level. https://mahtodeepak05.wordpress.com/2014/12/17/aggregate-function-nesting-in-oracle/ Hence Two level Deep is the max you can go with nested aggregate functions in Oracle. Logically that the way it should be, Third aggregation functions wont have any group to act on as previous aggregations functions “SUM” had already produce singular output.
I agree BCD
B, C, D for sure
B,C,D is correct
BCDE is right for me. E- We can use upper for only one and we can use CONCAT for more than two, isn't that correct?
Why not E? They can only accept one argument, they can also accept more. Is different when we use the word MUST.... I'm not a native English speaker...
C, D, and E
Sorry, B,C,D is the correct one