FC0-U71 Data and Database Fundamentals Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  INSERT INTO

  Why this is correct

  INSERT INTO appends new rows to a table, satisfying the requirement to add data rather than modify structure or retrieve it. Unlike UPDATE, which alters existing rows, or CREATE, which defines a new table, INSERT INTO specifies the target table and supplies values for each column, directly fulfilling the scenario.

• ✗

  ADD

  Why it's wrong here

  ADD is not a standalone SQL statement; it appears only as a clause, such as ALTER TABLE ... ADD COLUMN, which changes table structure rather than inserting row data. It would be correct when extending a table's schema with a new column.

• ✗

  CREATE

  Why it's wrong here

  CREATE defines new database objects such as tables, views or indexes; it does not populate a table with row data. It is tempting because it is the standard command for bringing a table into existence, which would be the right choice when the table itself does not yet exist.

• ✗

  UPDATE

  Why it's wrong here

  UPDATE modifies values in existing rows via SET, so it cannot insert a new row. It is tempting because it is the everyday command for changing table data, and it would be the right choice when correcting a stored value or altering an existing record's columns.