Basic SQL Commands Quiz - CBSE Class 10 Computer Science

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

This CBSE Class 10 Computer Science practice quiz has 18 multiple-choice questions on Basic SQL Commands, and 18 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. Which SQL command is used to retrieve data from a database?

   1. SELECT
   2. INSERT
   3. DELETE
   4. UPDATE
   Show answer

   Answer: A. SELECT

   The SELECT command is used to retrieve data from a database. It allows you to specify which columns of data you want to display.

2. How do you update a single column in SQL?

   1. UPDATE table_name SET column=value WHERE condition;
   2. CHANGE table_name column=value;
   3. SET column=value IN table_name WHERE condition;
   4. MODIFY table_name SET column=value;
   Show answer

   Answer: A. UPDATE table_name SET column=value WHERE condition;

   The UPDATE command is used in SQL to change existing data. The SET clause specifies the column to change and the WHERE clause specifies which rows should be updated.

3. What does the COUNT() function do?

   1. Counts the number of rows
   2. Calculates the sum of a column
   3. Finds the average value of a column
   4. Returns the first row
   Show answer

   Answer: A. Counts the number of rows

   The COUNT() function is used to count the number of rows returned by a query.

4. Which command is used to change the structure of a table?

   1. ALTER TABLE
   2. MODIFY TABLE
   3. UPDATE TABLE
   4. CHANGE TABLE
   Show answer

   Answer: A. ALTER TABLE

   The ALTER TABLE command is used to add, delete, or modify columns in an existing table.

5. Which command is used to remove a table and the data within it permanently?

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

   Answer: A. DROP TABLE

   The DROP TABLE command permanently removes a table, along with all of its data, from the database.

More questions in this quiz

Answers and explanations are in the full quiz.

1. What does the SQL command 'INSERT' do?
2. Which clause is used with SELECT to filter the records?
3. What is the function of the ORDER BY clause in SQL?
4. What is a primary key?
5. Which SQL function is used to find the highest value in a column?
6. How can you rename a column in a result set?
7. What does the SQL DISTINCT keyword do?
8. Which SQL statement is used to modify data in a database?
9. How do you select unique values from a column in SQL?
10. Which SQL keyword is used to set a condition for the grouped results in a SELECT statement?
11. In SQL, which clause can be used to specify the number of records to return?
12. What is a foreign key?
13. Which SQL clause is used to combine rows from two or more tables, based on a related column between them?

More quizzes

• Introduction to SQL▶ Play

Browse all Database Concepts quizzes

More to play