Question
Explain how CRUD operations are mapped to SQL. statements, with suitable example.
Answer :
Word Count : 290
_____ ____ ____ ________ _________ _______ ________.
_______ ___ __________ ____ ____ ________ _____ ________ _____.
_________ ________ __________ ___ ___.
________ ____ __________ ______ ___ __________ _______ __________ ______ _________ ____.
___ ______ _________ ___ ______ _____ _____ ________ ______ _____ _______ _________.
___ _______ ____ _________ ____ _____.
_______ ______ ______ _______ ___ _________ _____ ____ __________ _________ ______.
__________ ______ ________ _______ _____ _________.
_______ __________ _____ _______ ____ __________.
_______ __________ ________ __________ ______ ________ ________.
________ ____ ____ __________ ______ _____ ___.
______ ________ _________ __________ _____ ____ ______ ____.
________ _____ __________ ______ ______ ___ _______ _________ _____ _____.
_________ _________ ___ ____ ______ ______ ____ ___ _________ _______.
__________ _____ _____ ___ ________ ______.
____ _________ ____ ______ _______ ______ _______ ____ ___ ___.
___ _________ _________ ____ _____.
__________ ______ ____ _____ _________ _________ _________ _____.
__________ ______ _______ _______ ______.
_____ ____ _________ ___ _______ _______.
_____ _____ _______ ____ ___ __________ _______ _________ ______.
__________ __________ ___ _______ _____ __________.
____ ____ _________ _________ ____ ___ ____ ________ ____ ______.
Skip in 10
CRUD operations (Create, Read, Update, Delete) are the basic functions for managing data in a relational database, and they are directly mapped to SQL statements. These operations form the foundation for interacting with databases and are typically performed via SQL commands.
1. Create (C): This operation involves inserting new data into the database. In SQL, this is done using the `INSERT INTO` statement. For example:
```sql
INSERT INTO Users (UserID, Name, Age) VALUES (1, 'John Doe', 25);
```
This query adds a new user with ID 1, name 'John Doe', and age 25 into the "Users" table.
2. Read (R): The Read operation retrieves
_______ ___ __________ ____ ____ ________ _____ ________ _____.
_________ ________ __________ ___ ___.
________ ____ __________ ______ ___ __________ _______ __________ ______ _________ ____.
___ ______ _________ ___ ______ _____ _____ ________ ______ _____ _______ _________.
___ _______ ____ _________ ____ _____.
_______ ______ ______ _______ ___ _________ _____ ____ __________ _________ ______.
__________ ______ ________ _______ _____ _________.
_______ __________ _____ _______ ____ __________.
_______ __________ ________ __________ ______ ________ ________.
________ ____ ____ __________ ______ _____ ___.
______ ________ _________ __________ _____ ____ ______ ____.
________ _____ __________ ______ ______ ___ _______ _________ _____ _____.
_________ _________ ___ ____ ______ ______ ____ ___ _________ _______.
__________ _____ _____ ___ ________ ______.
____ _________ ____ ______ _______ ______ _______ ____ ___ ___.
___ _________ _________ ____ _____.
__________ ______ ____ _____ _________ _________ _________ _____.
__________ ______ _______ _______ ______.
_____ ____ _________ ___ _______ _______.
_____ _____ _______ ____ ___ __________ _______ _________ ______.
__________ __________ ___ _______ _____ __________.
____ ____ _________ _________ ____ ___ ____ ________ ____ ______.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.