Multiple choice technology databases

What are the two types of SQL Functions?

  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL functions are categorized into Single-row functions (operate on each row independently) and Multiple-row functions (operate on groups of rows). Single-row includes character, number, date, conversion functions. Multiple-row includes aggregate functions like SUM, COUNT, AVG, etc.

Keep practicing — related questions