List characteristics of SQL.
In : IMCA Subject : Introduction to RDBMS1. **Used to Work with Tables**
SQL helps you create, manage, and get data from tables in a database.
2. **Easy to Learn and Use**
It uses simple English-like commands like `SELECT`, `INSERT`, `UPDATE`, `DELETE`.
3. **Works with Relationships**
SQL helps connect data from different tables using keys like **Primary Key** and **Foreign Key**.
4. **Supports Multiple Users**
Many people can use and work with the same database at the same time without losing data.
5. **Keeps Data Safe and Accurate**
It supports **ACID properties** — meaning data stays correct and safe even during errors or crashes.
6. **Allows Filtering and Sorting**
You can search for specific data, sort it, group it, and do calculations using SQL.
7. **Has Predefined Commands**
Comes with built-in commands for:
- Creating databases/tables
- Inserting/updating/deleting data
- Controlling access and security
8. **Runs on All Major RDBMS**
Works the same way in systems like MySQL, Oracle, SQL Server, PostgreSQL, etc., though some features may vary.
9. **Supports Transactions**
You can group multiple operations together and make sure they all happen or none do (using `COMMIT` and `ROLLBACK`).
10. **Handles Large Amounts of Data**
SQL is powerful enough to manage big databases with millions of records efficiently.