1. Which SQL command is used to retrieve data from a database?
Explanation: The SELECT command is used to retrieve data from a database table.
Report for correction2. Which SQL statement is used to insert data into a table?
Explanation: The INSERT INTO statement is used to insert data into a table.
Report for correction3. Which SQL clause is used to combine rows from two or more tables?
Explanation: The JOIN clause is used to combine rows from two or more tables based on a related column.
Report for correction4. What SQL function is used to count the number of rows in a table?
Explanation: The COUNT function is used to count the number of rows in a table or the number of values in a specified column.
Report for correction5. What SQL command is used to delete a table from a database?
Explanation: The DROP command is used to delete a table from a database.
Report for correction6. Which SQL function is used to find the highest value in a column?
Explanation: The MAX function is used to find the highest value in a column.
Report for correction7. Which SQL command is used to add a new column to an existing table?
Explanation: The ALTER TABLE ADD COLUMN command is used to add a new column to an existing table.
Report for correction8. Which SQL function is used to find the lowest value in a column?
Explanation: The MIN function is used to find the lowest value in a column.
Report for correction9. What SQL clause is used to limit the number of rows returned by a SELECT statement?
Explanation: The LIMIT clause is used to restrict the number of rows returned by a SELECT statement in databases like MySQL and PostgreSQL.
Report for correction10. Which SQL command is used to update data in a table?
Explanation: The UPDATE command is used to modify existing data in a table.
Report for correction11. What SQL statement is used to change existing data in a table?
Explanation: The UPDATE statement is used to change or modify existing data in a table.
Report for correction12. What SQL command is used to change the structure of an existing table?
Explanation: The ALTER TABLE command is used to change the structure of an existing table; such as adding or modifying columns.
Report for correction13. Which of the following is not a NoSQL database?
Explanation: MySQL is a Relational database management system (RDBMS) that uses SQL, making it a traditional SQL database.
Report for correction14. Which SQL command is used to create a new table?
Explanation: The CREATE TABLE command is used to create a new table in a database.
Report for correction15. What SQL operator is used to negate a condition in a WHERE clause?
Explanation: The NOT operator is used to negate a condition in a WHERE clause; reversing its logical outcome.
Report for correction16. Which SQL operator is used to combine multiple conditions in a WHERE clause?
Explanation: The AND operator is used to combine multiple conditions in a WHERE clause.
Report for correction17. Which SQL statement is used to delete data from a table?
Explanation: The DELETE statement is used to remove data from a table.
Report for correction18. What does SQL stand for?
Explanation: SQL stands for Structured Query Language; which is used for managing and manipulating relational databases.
Report for correction19. What is the purpose of the SQL LIKE operator?
Explanation: The LIKE operator is used to filter rows based on a specified pattern in a SELECT statement.
Report for correction20. What is the purpose of the SQL DISTINCT keyword?
Explanation: The DISTINCT keyword is used to retrieve unique values from a specified column in a SELECT statement.
Report for correction21. What is the purpose of the SQL HAVING clause?
Explanation: The HAVING clause is used to filter the grouped rows in a SELECT statement based on a condition.
Report for correction22. What is the purpose of the SQL ORDER BY clause?
Explanation: The ORDER BY clause is used to sort the rows in the result set of a SELECT statement based on specified columns.
Report for correction23. Which SQL function is used to find the average value of a numeric column?
Explanation: The AVG function is used to calculate the average value of a numeric column in a table.
Report for correction24. Which SQL function is used to find the sum of values in a numeric column?
Explanation: The SUM function is used to calculate the sum of values in a numeric column.
Report for correction25. What SQL clause is used to group rows in a SELECT statement?
Explanation: The GROUP BY clause is used to group rows in a SELECT statement based on specified columns.
Report for correction26. What SQL clause is used to filter rows in a SELECT statement?
Explanation: The WHERE clause is used to filter rows in a SELECT statement based on a specified condition.
Report for correction