Use of SQL to Search for Data (AQA GCSE Computer Science): Quizzes
📚Quizzes
Practise the questions
12 questions from this quiz
ShowHide
Practise the questions
12 questions from this quiz
What does SQL stand for?
What does SQL stand for?
Structured Query Language
Which two SQL keywords are compulsory in every query?
Which two SQL keywords are compulsory in every query?
SELECT and FROM
Which SQL keywords are optional in a query?
Which SQL keywords are optional in a query?
WHERE and ORDER BY
What does the SELECT keyword do in SQL?
What does the SELECT keyword do in SQL?
Chooses which fields/columns to show
What does the asterisk (*) mean in SELECT * FROM Student?
What does the asterisk (*) mean in SELECT * FROM Student?
Select all fields from the table
What does ORDER BY Surname DESC do?
What does ORDER BY Surname DESC do?
Sorts surnames Z to A
If you don't specify ASC or DESC, what is the default sort order?
If you don't specify ASC or DESC, what is the default sort order?
ASC (ascending)
What does the WHERE clause do in an SQL query?
What does the WHERE clause do in an SQL query?
Filters records by conditions
What does the OR operator do in a WHERE clause?
What does the OR operator do in a WHERE clause?
Matches one condition OR another
What is a primary key in a database table?
What is a primary key in a database table?
A unique identifier for each record
What is a foreign key?
What is a foreign key?
A reference to another table's key
How do you specify which table a field comes from in multi-table queries?
How do you specify which table a field comes from in multi-table queries?
TableName.FieldName