Databases and SQL

Class 12 · Computer Science · 6 questions

Name: ____________________   Date: ____________

1. Which SQL command retrieves data?

   • A DELETE
   • B UPDATE
   • C SELECT
   • D INSERT

2. Which SQL command adds a new row?

   • A DROP
   • B INSERT
   • C SELECT
   • D ALTER

3. The clause used to filter rows in SQL is:

   • A WHERE
   • B GROUP
   • C ORDER
   • D FROM

4. A foreign key is used to:

   • A Hide data
   • B Sort rows
   • C Delete a table
   • D Link two tables

5. Which clause sorts the result of a query?

   • A JOIN
   • B WHERE
   • C HAVING
   • D ORDER BY

6. Removing repeated data from tables is called:

   • A Backup
   • B Compilation
   • C Normalisation
   • D Formatting