FC0-U61 · Question #658
A database administrator needs to add a record to an existing table. Which of the following statements would the administrator MOST likely use?
The correct answer is A. INSERT. To add a new record to an existing table in a database, the administrator would most likely use the INSERT statement.
Question
A database administrator needs to add a record to an existing table. Which of the following statements would the administrator MOST likely use?
Options
- AINSERT
- BSELECT
- CUDATE
- DDELETE
How the community answered
(46 responses)- A91% (42)
- B2% (1)
- D7% (3)
Why each option
To add a new record to an existing table in a database, the administrator would most likely use the `INSERT` statement.
The `INSERT` SQL statement is specifically used to add one or more new rows (records) of data into a table. It allows the administrator to specify the columns and their corresponding values for the new record being added.
`SELECT` is used to retrieve data from a database table, not to add new records.
`UDATE` is a misspelling; the correct SQL command to modify existing records is `UPDATE`, which does not add new records.
`DELETE` is used to remove existing records from a table, not to add new ones.
Concept tested: SQL DML - Inserting data
Source: https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.