Multiple choice technology databases

Single-row functions can appear in which of the following (choose all that apply):

  1. WHERE clauses

  2. START WITH and CONNECT BY clauses

  3. select lists

  4. HAVING clauses
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Single-row functions can be used in almost any clause of a SQL query. This includes the SELECT list, the WHERE clause, the START WITH and CONNECT BY hierarchical clauses, and the HAVING clause, as they operate on individual rows.

Keep practicing — related questions