SQL (OCR A-Level 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
Why is SQL important as a standardised language?
Why is SQL important as a standardised language?
Ensures consistency across databases
How many main categories do SQL commands divide into?
How many main categories do SQL commands divide into?
Four
What is Data Definition Language (DDL) used for?
What is Data Definition Language (DDL) used for?
Define or modify database structure
What is Data Manipulation Language (DML) used for?
What is Data Manipulation Language (DML) used for?
Manipulate data within tables
What does the SELECT command do?
What does the SELECT command do?
Fetches records based on criteria
What does the UPDATE command do?
What does the UPDATE command do?
Updates existing records in a table
What does the DELETE command do?
What does the DELETE command do?
Deletes records based on conditions
What is the WHERE clause used for in SQL?
What is the WHERE clause used for in SQL?
Retrieves rows by setting conditions
Which are aggregate functions in SQL?
Which are aggregate functions in SQL?
COUNT, AVG, SUM, MAX, MIN
What does INNER JOIN do?
What does INNER JOIN do?
Combines rows where match in both tables
What can happen if WHERE is missing in UPDATE or DELETE?
What can happen if WHERE is missing in UPDATE or DELETE?
Unintended modifications to all records