1Z0-071 practice question 2 of 35

Which three statements are true about single row functions?

Full set: 326 questions
Answer options
A: They can be used only in the where clause of a select statement.
B: They can accept only one argument.
C: They return a single result row per table.
D: The argument can be a column name, variable, literal or an expression. Correct answer
E: They can be nested to any level. Correct answer
F: The date type returned can be different from the data type of the argument. Correct answer
Correct Answer:
D. The argument can be a column name, variable, literal or an expression.; E. They can be nested to any level.; F. The date type returned can be different from the data type of the argument.
Explanation

Single-row functions in Oracle SQL are versatile. Their arguments can be literals, variables, column values, or complex expressions. They can be nested within each other to build more complex logic, for example, UPPER(SUBSTR(name, 1, 10)). A key characteristic is that the data type of the value returned by the function does not have to match the data type of its argument. For instance, the TOCHAR function takes a DATE or NUMBER and returns a VARCHAR2 string.

Why Incorrect

A: Single-row functions can be used in many clauses, including the SELECT list, WHERE, ORDER BY, and GROUP BY clauses. B: Many single-row functions, such as SUBSTR, REPLACE, and ROUND, accept multiple arguments. C: They return one result per row processed, not one result per table. Group functions return one result per group of rows.

References

1. Oracle Database SQL Language Reference, 21c, "Functions". This chapter provides numerous examples demonstrating that functions can be nested (E), accept various expressions as arguments (D), and return data types different from the input (F), such as TOCHAR(hiredate).

2. Oracle Database SQL Language Reference, 21c, "SQL Expressions". This section details the valid components of an expression, which includes literals, columns, and function invocations, confirming they can be used as arguments to other functions.

Scroll to Top