200-301 · Question #333
Which CRUD operation modifies an existing table or view?
The correct answer is D. update. The CRUD operation that modifies an existing table or view is Update, which allows changes to be made to existing data records.
Question
Options
- Aread
- Bcreate
- Creplace
- Dupdate
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- D92% (23)
Why each option
The CRUD operation that modifies an existing table or view is `Update`, which allows changes to be made to existing data records.
`Read` (or Retrieve) operations are used to fetch data from a database without altering it.
`Create` operations are used to add new data records to a database table.
`Replace` is not a standard, fundamental CRUD operation; while some systems have similar functionalities, `Update` is the explicit CRUD operation for modification.
The `Update` operation, part of the CRUD (Create, Read, Update, Delete) paradigm, is specifically used to modify existing data entries within a database table or view without creating new ones or deleting the existing ones entirely.
Concept tested: CRUD operations (Update)
Source: https://learn.microsoft.com/en-us/previous-versions/dotnet/framework/data/adonet/crud-operations
Topics
Community Discussion
No community discussion yet for this question.