Multiple choice technology databases

Which of these following features are correct if SQL is a set-oriented language?

  1. Individual rows must have a unique identifier

  2. Sets of users can be managed in groups

  3. One statement can affect multiple rows

  4. SQL statements can be placed within blocks of code

  5. All the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL is a set-oriented language because it operates on sets of rows rather than processing rows individually. A single SQL statement can affect multiple rows simultaneously (UPDATE, DELETE, or bulk INSERT), which is the essence of set-oriented processing. This distinguishes SQL from procedural languages that process one record at a time.

Keep practicing — related questions