Structured Query Language (SQL) (AQA GCSE Computer Science): Quizzes
📚Quizzes
Practise the questions
12 questions from this quiz
ShowHide
Practise the questions
12 questions from this quiz
What are the three essential SQL commands for manipulating data in database tables?
What are the three essential SQL commands for manipulating data in database tables?
INSERT, UPDATE, DELETE
What does the INSERT command do in SQL?
What does the INSERT command do in SQL?
Adds brand new rows of data to a table
In an INSERT statement, how must field names and values be arranged?
In an INSERT statement, how must field names and values be arranged?
They must match up perfectly in order
What does the UPDATE command allow you to do?
What does the UPDATE command allow you to do?
Modify existing records in a database
Which keyword in UPDATE specifies what changes to make to the data?
Which keyword in UPDATE specifies what changes to make to the data?
SET
What happens if you run UPDATE without a WHERE clause?
What happens if you run UPDATE without a WHERE clause?
Every single record in the table changes
Why is DELETE described as the most dangerous SQL command?
Why is DELETE described as the most dangerous SQL command?
It permanently removes data
Which clause should almost always be included with DELETE commands?
Which clause should almost always be included with DELETE commands?
WHERE
What happens if you use DELETE FROM without a WHERE clause?
What happens if you use DELETE FROM without a WHERE clause?
All records deleted, table structure remains
What is the purpose of the WHERE clause in UPDATE and DELETE commands?
What is the purpose of the WHERE clause in UPDATE and DELETE commands?
Acts as a safety net to target specific records
What should you do first to test WHERE conditions before running UPDATE or DELETE?
What should you do first to test WHERE conditions before running UPDATE or DELETE?
Use them in a SELECT statement
Why is the order important in INSERT statements?
Why is the order important in INSERT statements?
Field names and values must match exactly