SQL Basics Quiz - CBSE Class 10 ICT

Free practice quiz: SQL Basics (CBSE Class 10 ICT). 19 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 10 ICT practice quiz has 19 multiple-choice questions on SQL Basics, and 19 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 keyword is used to retrieve data from a database?

   1. FETCH
   2. GET
   3. SELECT
   4. DISPLAY
   Show answer

   Answer: C. SELECT

   The SELECT keyword is used in SQL to fetch data from a database. It is the most commonly used keyword for querying data.

2. Which SQL statement is used to delete records from a table?

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

   Answer: C. DELETE

   The DELETE statement is used to remove existing records from a table in SQL.

3. Which SQL function will return the number of records in a table?

   1. SUM()
   2. COUNT()
   3. TOTAL()
   4. NUMBER()
   Show answer

   Answer: B. COUNT()

   The COUNT() function in SQL returns the number of rows that match a specified criteria.

4. Which keyword is used to change the structure of an existing database table?

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

   Answer: A. ALTER

   The ALTER TABLE statement is used to modify the structure of an existing table, such as adding or deleting columns.

5. Which SQL constraint is used to ensure unique values in a column?

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

   Answer: C. UNIQUE

   The UNIQUE constraint ensures that all values in a column are different from each other.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which of the following is a valid SQL keyword for sorting data?
2. How do you select all the columns from a table named 'students'?
3. Which SQL clause is used to filter the result set?
4. How can you update the last name of all employees in the 'employees' table to 'Smith'?
5. Which SQL keyword is used to prevent duplicate entries in a query result?
6. What is the purpose of the SQL JOIN operation?
7. Which SQL clause is used for conditional selection of data based on aggregate calculations?
8. What does the SQL wildcard '%' represent?
9. Which SQL function calculates the total sum of a numeric column?
10. What SQL clause is used to group result set data based on one or more columns?
11. Which of the following keywords is used to remove a table from a database?
12. How do you retrieve the first four characters of a string in SQL?
13. Which SQL statement is used to make a copy of data from one table to another?
14. How can you remove duplicate rows from a SQL result set?

More quizzes

• Database Management Systems▶ Play
• Introduction to Databases▶ Play

Browse all Database Management quizzes

More to play