Which of the following represents the core operations in data manipulation using SQL?

The core operations in data manipulation using SQL are encapsulated in the acronym CRUD, which stands for Create, Read, Update, and Delete. These operations represent the fundamental functions that can be performed on data stored in a database.

• Create refers to adding new records to a database. This is typically executed using the SQL command INSERT, allowing users to introduce new data entries.

• Read is the operation for retrieving data from the database using the SELECT statement. This operation enables users to access data for analysis or reporting.

• Update facilitates modifying existing records in the database with the UPDATE command, allowing for changes to be made to specific data without affecting the entire dataset.

• Delete provides the capability to remove records from the database using the DELETE command. This operation is essential for maintaining data integrity and relevance by ensuring that outdated or unnecessary information can be removed.

This combination of operations—Create, Read, Update, and Delete—forms the foundation of data management practices in relational databases, making this option the most accurate representation of core data manipulation tasks in SQL. Other options either miss critical operations or include processes not central to database management.