Difficulty: Easy
Correct Answer: Incorrect
Explanation:
Introduction / Context:
SQL provides well-defined statements for data manipulation. This item tests whether the statement “ADD command inserts one row or many rows from a query” reflects standard SQL terminology and behavior across common database systems.
Given Data / Assumptions:
Concept / Approach:
The SQL statement for inserting data is INSERT. It supports inserting a single row (INSERT INTO ... VALUES (...)) or multiple rows either via multiple VALUES clauses or by selecting from another result set (INSERT INTO ... SELECT ...). The keyword ADD is not a DML verb for rows; rather, ADD typically appears in ALTER TABLE to add a column, constraint, or index, depending on the DBMS dialect.
Step-by-Step Solution:
Verification / Alternative check:
Try example patterns: INSERT INTO t(col1,col2) VALUES (1, 'a');INSERT INTO t(col1,col2) SELECT colA,colB FROM u; Both are valid; there is no “ADD INTO” for rows in standard SQL.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing DML (INSERT) with DDL ALTER TABLE ... ADD. Remember that adding rows uses INSERT; adding columns or constraints may use ADD.
Final Answer:
Incorrect
Discussion & Comments