ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

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 Hide Answer
Suggested Answer: BDF 🗳️
by holdfaststrongly at Sept. 21, 2022, 1:12 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dexdinh91
6 months, 1 week ago
Selected Answer: BDF
BDF is correct
upvoted 4 times
...
holdfaststrongly
8 months, 3 weeks ago
BDF is correct. Can be nesed to any level.
upvoted 1 times
...
heoj10272
9 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
9 months, 3 weeks ago
E is not right either because of the word "only".
upvoted 2 times
...
holdfaststrongly
9 months, 3 weeks ago
DEF. B is wrong. Nested only to 255 levels.
upvoted 1 times
Orxan_H
2 months, 2 weeks ago
this applies to subquery (255 levels). Functions unlimited
upvoted 1 times
...
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago