Q1: 1. What does SQL stand for?

• A) Structured Query Language
• B) Sequential Query Language
• C) Systematic Query Language
• D) Standardized Query Language

Q2: 2. Which SQL keyword is used to retrieve data from a database?

• A) GET
• B) FETCH
• C) SELECT
• D) PICK

Q3: 3. In SQL, which clause is used to filter rows based on a specified condition?

• A) WHERE
• B) HAVING
• C) FILTER
• D) SEARCH

Q4: 4. Which SQL statement is used to insert new data into a database table?

• A) ADD
• B) PUT
• C) INSERT INTO
• D) CREATE

Q5: 5. What is the purpose of the SQL command "UPDATE"?

• A) To delete data from a table
• B) To modify existing data in a table
• C) To create a new table
• D) To retrieve data from a table

Q6: 6. Which SQL function is used to find the total number of rows in a table?

• A) COUNT
• B) SUM
• C) TOTAL
• D) TALLY

Q7: 7. What is the purpose of the SQL command "GROUP BY"?

• A) To sort rows in a table
• B) To filter rows based on a condition
• C) To group rows with the same value
• D) To join multiple tables

Q8: 8. Which SQL operator is used to combine two or more conditions in a WHERE clause?

• A) AND
• B) OR
• C) NOT
• D) XOR

Q9: 9. What is the function of the SQL command "ORDER BY"?

• A) To delete rows from a table
• B) To update rows in a table
• C) To sort rows based on a specified column
• D) To insert new rows into a table

Q10: 10. Which SQL statement is used to delete rows from a table?

• A) REMOVE
• B) DELETE
• C) ERASE
• D) TRUNCATE

Q11: 11. In SQL, which keyword is used to retrieve unique records from a table?

• A) DISTINCT
• B) UNIQUE
• C) SINGULAR
• D) ONLY

Q12: 12. What is the purpose of the SQL command "JOIN"?

• A) To filter rows in a table
• B) To group rows together
• C) To combine rows from two or more tables
• D) To sort rows in a table

Q13: 13. Which SQL function is used to find the highest value in a column?

• A) MAX
• B) TOP
• C) HIGH
• D) PEAK

Q14: 14. What does the SQL command "LIKE" do?

• A) Matches exact values
• B) Matches partial values
• C) Matches case-sensitive values
• D) Matches numeric values

Q15: 15. Which SQL statement is used to modify the structure of a table?

• A) CHANGE TABLE
• B) ALTER TABLE
• C) MODIFY TABLE
• D) UPDATE TABLE

Q16: 16. What is the purpose of the SQL command "DISTINCT"?

• A) To filter rows based on a condition
• B) To retrieve unique records from a table
• C) To combine rows from different tables
• D) To group rows with the same value

Q17: 17. Which SQL function is used to calculate the average value of a column?

• A) AVG
• B) MEAN
• C) AVERAGE
• D) TOTAL

Q18: 18. In SQL, what does the "HAVING" clause do?

• A) Filters rows before grouping
• B) Filters rows after grouping
• C) Orders rows in a table
• D) Joins multiple tables

Q19: 19. Which SQL statement is used to create a new database?

• A) MAKE DATABASE
• B) CREATE DATABASE
• C) BUILD DATABASE
• D) FORM DATABASE

Q20: 20. What is the purpose of the SQL command "UNION"?

• A) To combine the results of two or more SELECT statements
• B) To filter rows based on a condition
• C) To group rows together
• D) To sort rows in a table

Q21: 21. Which SQL function is used to find the minimum value in a column?

• A) MIN
• B) SMALL
• C) LOW
• D) MINIMUM

Q22: 22. What is the purpose of the SQL command "TRUNCATE TABLE"?

• A) To delete all rows from a table
• B) To update rows in a table
• C) To insert new rows into a table
• D) To retrieve data from a table

Q23: 23. Which SQL statement is used to create a new table?

• A) MAKE TABLE
• B) CREATE TABLE
• C) BUILD TABLE
• D) FORM TABLE

Q24: 24. In SQL, which keyword is used to specify a range of values in a WHERE clause?

• A) BETWEEN
• B) RANGE
• C) AMONG
• D) WITHIN

Q25: 25. What does the SQL command "NULL" represent?

• A) An empty string
• B) A missing or unknown value
• C) A zero value
• D) A placeholder value