Exam 1z0-071 topic 1 question 26 discussion

Actual exam question from Oracle's 1z0-071

Question #: 26
Topic #: 1

[All 1z0-071 Questions]

Which three statements are true about single-row functions? (Choose three.)

A. They return a single result row per table.
B. They can be nested to any level.
C. They can accept only one argument.
D. The argument can be a column name, variable, literal or an expression.
E. They can be used only in the WHERE clause of a SELECT statement.
F. The data type returned can be different from the data type of the argument.

Show Suggested Answer

Suggested Answer: BDF 🗳️

by holdfaststrongly at Sept. 21, 2022, 1:12 a.m.

Comments

Submit Cancel

826cb95

3 months, 2 weeks ago

Selected Answer: BDF

BDF is correct. Can be nested to any level.

upvoted 1 times

...

dexdinh91

1 year ago

Selected Answer: BDF

BDF is correct

upvoted 4 times

...

holdfaststrongly

1 year, 3 months ago

BDF is correct. Can be nesed to any level.

upvoted 1 times

...

heoj10272

1 year, 3 months ago

Answer is BDF. check the discussion of the link. https://www.examtopics.com/discussions/oracle/view/20182-exam-1z0-071-topic-2-question-46-discussion/

upvoted 2 times

...

holdfaststrongly

1 year, 4 months ago

E is not right either because of the word "only".

upvoted 2 times

...

holdfaststrongly

1 year, 4 months ago

DEF. B is wrong. Nested only to 255 levels.

upvoted 1 times

Orxan_H

9 months ago

this applies to subquery (255 levels). Functions unlimited

upvoted 2 times

...