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.

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 quizzes

• Database Management Systems
• Introduction to Databases

Browse all Database Management quizzes