1. What SQL keyword is used to sort the result set in ascending or descending order based on one or more columns?
- **Answer:** The SQL keyword used to sort the result set is `ORDER BY`.
2. What SQL command is used to remove a table from the database?
- **Answer:** The SQL command used to remove a table from the database is `DROP TABLE`.
3. What SQL function is used to count the number of rows in a result set or a specific column?
- **Answer:** The SQL function used to count rows is `COUNT()`.
4. What SQL command is used to retrieve data from multiple tables simultaneously while allowing unmatched rows in one table?
- **Answer:** The SQL command used to retrieve data from multiple tables while allowing unmatched rows in one table is `LEFT JOIN` or `LEFT OUTER JOIN`.
5. What SQL keyword is used to specify a condition for selecting rows based on multiple criteria using logical operators such as AND, OR, and NOT?
- **Answer:** The SQL keyword used to specify multiple criteria using logical operators is `AND`, `OR`, and `NOT`.
These SQL concepts are essential for data retrieval, manipulation, and database management tasks.
