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

Exam 1z0-051 All Questions

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

Exam 1z0-051 topic 2 question 33 discussion

Actual exam question from Oracle's 1z0-051
Question #: 33
Topic #: 2
[All 1z0-051 Questions]

Which four are attributes of single row functions? (Choose four.)

  • A. cannot be nested
  • B. manipulate data items
  • C. act on each row returned
  • D. return one result per row
  • E. accept only one argument and return only one value
  • F. accept arguments which can be a column or an expression
Show Suggested Answer Hide Answer
Suggested Answer: BCDF 🗳️
manipulate data items, act on each row returned, return one result per row, and accept arguments that can be a column or expression.
Incorrect answer:

Ais not single row attributes -
Efunctions can accept more than one argument, e.g NVL2
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-5
by thuthuysphn58 at April 4, 2025, 7:07 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
Currently there are no comments in this discussion, be the first to comment!
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