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.

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 quizzes

• Basic SQL Commands

Browse all Database Concepts quizzes