Structured Query Language (SQL) (AQA A-Level Computer Science): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What type of programming language is SQL?
What type of programming language is SQL?
A specialised language for databases
What does the PRIMARY KEY constraint identify in a table?
What does the PRIMARY KEY constraint identify in a table?
Field that uniquely identifies each record
Why is varchar more space-efficient than character for storing names?
Why is varchar more space-efficient than character for storing names?
Names vary in length; varchar adjusts
How many decimal places can the Real data type store?
How many decimal places can the Real data type store?
Up to 7 decimal places
When using INSERT INTO with column names, how must values be ordered?
When using INSERT INTO with column names, how must values be ordered?
Same order as the column names listed
What happens if you use UPDATE without a WHERE clause?
What happens if you use UPDATE without a WHERE clause?
Every record in the table is updated
What does DELETE FROM Customer; do to the table?
What does DELETE FROM Customer; do to the table?
Removes all records, keeps structure
What does ORDER BY CustomerName DESC do?
What does ORDER BY CustomerName DESC do?
Sorts names Z to A in descending order
When do concurrent access problems occur?
When do concurrent access problems occur?
When multiple users write to same location
What does serialisation do to prevent concurrent access problems?
What does serialisation do to prevent concurrent access problems?
Processes transactions sequentially