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 1 question 26 discussion

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

Which two statements are true regarding single row functions? (Choose two.)

  • A. They can be nested only to two levels.
  • B. They always return a single result row for every row of a queried table.
  • C. Arguments can only be column values or constant.
  • D. They can return a data type value different from the one that is referenced.
  • E. They accept only a single argument.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
A function is a program written to optionally accept input parameters, perform an operation, or return a single value. A function returns only one value per execution.
Three important components form the basis of defining a function. The first is the input parameter list. It specifies zero or more arguments that may be passed to a function as input for processing. These arguments or parameters may be of differing data types, and some are mandatory while others may be optional. The second component is the data type of its resultant value. Upon execution, only one value is returned by the function. The third encapsulates the details of the processing performed by the function and contains the program code that optionally manipulates the input parameters, performs calculations and operations, and generates a return value.
by algerianphoenix at Sept. 25, 2021, 12:48 p.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
algerianphoenix
3 years, 7 months ago
Answer B,D Correct.
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