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

Discussion

You can add a row using SQL in a database with which of the following?

  • A.
    ADD
  • B.CREATE
  • C.INSERT
  • D.MAKE

Answer: C

Correct answer: INSERT

INSERT is the SQL statement that adds rows to a table, in the form INSERT INTO table (col1, col2) VALUES (v1, v2), or with a SELECT in place of VALUES to add many rows from a query.

The distractors trade on the difference between data and structure. CREATE belongs to the data definition language and makes the table itself, not a row in it; ADD appears only as part of ALTER TABLE ... ADD COLUMN, which again changes structure; and MAKE is not SQL at all.

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

Post your comment

Please log in or register to post a comment.