1Z0-071 practice question 2 of 35
Which three statements are true about single row functions?
Full set: 326 questionsSingle-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.
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.
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.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
- Question 11You have the privileges to create any type of synonym. Which stalement will create a syno…
