Multiple choice

A Select/Delete/Update statement that does not have a where clause will _____.

  1. affect no record

  2. affect all the records

  3. return an error

  4. affect only the first record
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The where clause is an optional statement in a Select/Delete/Update statement. If it is omitted then the command will affect all the records of the table. For example,  the statement delete from employees will delete all the records in the table.

Keep practicing — related questions