SQL (OCR 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
What is SQL primarily used for?
What is SQL primarily used for?
Managing and querying databases
Which SQL command specifies which columns of data to retrieve?
Which SQL command specifies which columns of data to retrieve?
SELECT
What does the asterisk (*) mean in a SELECT statement?
What does the asterisk (*) mean in a SELECT statement?
All columns
Which SQL command specifies the table to retrieve data from?
Which SQL command specifies the table to retrieve data from?
FROM
What does the WHERE clause do in an SQL query?
What does the WHERE clause do in an SQL query?
Filters results by conditions
What does the > operator mean in SQL?
What does the > operator mean in SQL?
Greater than
What is the LIKE operator used for in SQL?
What is the LIKE operator used for in SQL?
Searching for patterns in text
What does the BETWEEN operator do?
What does the BETWEEN operator do?
Searches within a range
What is the IN operator used for?
What is the IN operator used for?
Specifying multiple values
When using the AND operator, what must be true?
When using the AND operator, what must be true?
Both conditions
When using the OR operator, what must be true?
When using the OR operator, what must be true?
At least one condition