SQL Basics Quiz

What does SQL stand for?

• Standard Query Language

• Sequential Query Language

• Simple Query Language

• Structured Query Language

Which SQL statement is essential for the IGCSE syllabus?

• UPDATE

• INSERT

• DELETE

• SELECT

What keyword is used to specify the table in a SELECT statement?

• TABLE

• FROM

• WHERE

• SELECT

In the query 'SELECT population FROM world WHERE name = 'Albania'', what does 'population' represent?

• The database name

• The table name

• The search criteria

• The field to display

Which wildcard character is used to select all fields in a table?

• *

• #

• %

• &

What does the 'LIKE' keyword do in a SQL query?

• Matches a pattern

• Specifies the table

• Selects all fields

• Sorts the results

Which Boolean operator can be used to combine multiple conditions in a WHERE clause?

• SUM

• ORDER BY

• LIKE

• AND

What does the 'ORDER BY' clause do in a SQL query?

• Sorts the results

• Counts the records

• Specifies the table

• Filters the results

What does the 'COUNT' function do in a SQL query?

• Sorts the results

• Counts the number of records

• Filters the results

• Adds up values

Which data types can the 'SUM' function be used on?

• Text and Integer

• Text and Real

• All data types

• Integer and Real