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

Study for the MTA Software Development Fundamentals Exam. Utilize flashcards and multiple choice questions, each with hints and explanations. Prepare effectively for your certification!

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