Which CRUD operation modifies an existing table or view?
Click on the arrows to vote for the correct answer
A. B. C. D.B.
The CRUD acronym stands for Create, Read, Update, and Delete. These are the four basic operations that can be performed on a database to manage its data.
Of these four operations, the one that modifies an existing table or view is the "Update" operation, which is option B in the given list of answers.
The "Update" operation allows you to modify or change the existing data within a table or view in a database. This operation can be used to update one or more rows within a table, and it can also be used to update specific columns or fields within a row.
When you perform an "Update" operation, you need to specify which table you want to update and which rows and columns you want to modify. You also need to provide the new values that you want to update the data with. Once the update command is executed, the changes are made to the data in the table or view.
In contrast, the "Create" operation is used to create a new table or view, the "Read" operation is used to retrieve data from a table or view, and the "Delete" operation is used to remove data from a table or view.
In summary, if you want to modify an existing table or view in a database, you need to perform an "Update" operation.