What are the various operations that we can perform on database?
Answers
Explanation:
insert select update and delete
Answer:
We can perform Insertion, Deletion, Updation, and Selection operations on the database. These are the essential operation.
Explanation:
Insertion Operation
Adding data to an existing database is called an insertion operation. It should be carried out in such a way that older data should not be overwritten. SQL is a query language that is used for writing queries for the database.
Deletion Operation
Deleting the data from the database that is of no use is called a deletion operation. It should be carried out in such a way that only the specified data is deleted from the database, and no other data should be affected by it.
Update Operation
Updation means modifying the data that is already in the database. We can change the type and actual data from the table of the database. Each update operation should be properly recorded in the database.
Selection Operation
Selection means selecting the required data from the database as per our criteria. This could be done only when all the data is accessible to us and all the data should be able to categorize and recognized by some means. For this, we use the primary key.
#SPJ2