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
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;
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
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...
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"
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.
yes, D is also correct …
see Question 30 > https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
avanand
Highly Voted 4 years, 1 month agodanito
4 years, 1 month agoantonica
3 months, 3 weeks agoelvegaa
3 years, 8 months agosaidov1981
3 years, 3 months agoOracle2020
Most Recent 3 months, 2 weeks agonautil2
9 months, 4 weeks agoemburria
2 years, 5 months agoryuah
2 years, 6 months agoGuhborges
2 years, 9 months agoGuhborges
2 years, 9 months agodbaclaudio
3 years, 6 months agothuto
1 year, 10 months agovaliantvimal
2 months, 2 weeks agoelvegaa
3 years, 8 months agoSimoneF
3 years, 7 months agoEkos
3 years, 8 months agoEkos
3 years, 7 months agodkmraju
3 years, 9 months agoyou1234
4 years agoama
4 years ago