A new row can be added to a database with which command?

Prepare for the MTA Software Development Fundamentals Exam! Access flashcards, multiple-choice questions, and detailed explanations to enhance your learning and ace your exam.

The command used to add a new row to a database is "INSERT." This command is a fundamental part of SQL (Structured Query Language) and is specifically designed to insert new records into a table within a database. When you use the INSERT statement, you specify the target table and the values for each column for the new record.

For example, an INSERT command would look like this: INSERT INTO table_name (column1, column2) VALUES (value1, value2); This clearly indicates the table you are adding to and specifies the details of the row being inserted.

Other commands, while they may serve different purposes, do not add new rows. An UPDATE command modifies existing records within a table rather than creating new ones. MODIFY is not a standard SQL command for adding rows; it is perhaps a confusion with other commands related to altering data structures. CREATE is used for establishing new tables or databases, not for inserting rows into existing ones. Thus, the INSERT command is the correct choice for adding new rows to a database.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy