Machine-translated by Google. Questions are authored in English.
Top

Discussion

The SQL ALTER statement can be used to:

  • A.
    change the table structure.
  • B.change the table data.
  • C.add rows to the table.
  • D.delete rows from the table.

Answer: A

Correct answer: change the table structure.

ALTER TABLE is a data definition statement: it adds or drops columns, changes data types and adds or removes constraints. Changing the data is the business of INSERT, UPDATE and DELETE, and confusing the two families is the error the distractors are built on.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.