Introduction to SQL Quiz - CBSE Class 10 Computer Science

Free practice quiz: Introduction to SQL (CBSE Class 10 Computer Science). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 10 Computer Science practice quiz has 20 multiple-choice questions on Introduction to SQL, and 20 of them come with an explanation. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz online. No sign-up needed.

Sample questions

1. What is SQL primarily used for?

   1. Data analysis
   2. Web development
   3. Database management
   4. Graphic designing
   Show answer

   Answer: C. Database management

   SQL is primarily used for accessing and managing databases.

2. How can you ensure the uniqueness of a column in a table?

   1. PRIMARY KEY
   2. FOREIGN KEY
   3. CHECK
   4. DEFAULT
   Show answer

   Answer: A. PRIMARY KEY

   A PRIMARY KEY constraint uniquely identifies each record in a database table.

3. How can you remove all records from a table without deleting the table?

   1. DELETE
   2. TRUNCATE
   3. DROP
   4. REMOVE
   Show answer

   Answer: B. TRUNCATE

   The TRUNCATE command deletes all rows in a table without logging individual row deletions.

4. Which command will remove a table from a database?

   1. DELETE TABLE
   2. CLEAR
   3. DROP TABLE
   4. TRUNCATE TABLE
   Show answer

   Answer: C. DROP TABLE

   DROP TABLE command removes a table and all its rows from the database.

5. In SQL, what purpose does the HAVING clause serve?

   1. It modifies the SELECT statement
   2. It specifies the sorting order
   3. It filters records after aggregation
   4. It changes data types
   Show answer

   Answer: C. It filters records after aggregation

   HAVING clause is used to filter records that work on summarized group results, similar to WHERE but for aggregated data.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which SQL command is used to fetch data from a database?
2. Which keyword in SQL is used to remove duplicate records?
3. Which command is used to add a new row in a table?
4. Which SQL keyword is used to retrieve data in ascending order?
5. What does the SQL command UPDATE do?
6. Which SQL function is used to count the number of records?
7. Which SQL clause is used to group rows that have the same values?
8. In SQL, how do you ensure a column cannot have a NULL value?
9. If you want to combine rows from two tables, which SQL operation would you use?
10. Which SQL function is used to find the maximum value in a column?
11. What does the SQL keyword 'LIKE' do?
12. Which keyword would you use in SQL to ensure certain conditions are met?
13. How do you rename a table in SQL?
14. Which of the following statements is true about a SQL JOIN operation?
15. What's the difference between an INNER JOIN and a LEFT JOIN in SQL?

More quizzes

• Basic SQL Commands▶ Play

Browse all Database Concepts quizzes

More to play