FC0-U61 · Question #884
Which of the following commands would most likely be used to add data to an existing database table?
The correct answer is B. INSERT. The INSERT command is used to add new records or rows to an existing database table. It specifies the table name, the column names, and the values to be inserted. For example, INSERT INTO Customers (Name, Age, City) VALUES ('Ali', 25, 'Lahore'); would add a new row to the…
Question
Which of the following commands would most likely be used to add data to an existing database table?
Options
- ASELECT
- BINSERT
- CALTER
- DCREATE
How the community answered
(27 responses)- B96% (26)
- C4% (1)
Explanation
The INSERT command is used to add new records or rows to an existing database table. It specifies the table name, the column names, and the values to be inserted. For example, INSERT INTO Customers (Name, Age, City) VALUES ('Ali', 25, 'Lahore'); would add a new row to the Customers table with the given values for Name, Age, and City. The SELECT command is used to query or retrieve data from a database table, not to add data. The ALTER command is used to modify the structure or definition of a database table, such as adding, deleting, or renaming columns. The CREATE command is used to make a new database object, such as a table, a view, or an index, not to add data to an existing table.
Topics
Community Discussion
No community discussion yet for this question.