Back to the full dot-point answer
SingaporeComputer ScienceQuick questions
Data, Information and Databases
Quick questions on SQL data manipulation explained: H2 Computing
4short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What are jOIN across tables?Show answer
A JOIN combines rows from two tables where a foreign key matches a primary key:
What is q1?Show answer
Write SQL to list the names of students with a mark above 80, sorted highest first, from Student(Name, Mark). [2 marks]
What is q2?Show answer
What does an UPDATE statement do if you forget the WHERE clause? [1 mark]
What is q3?Show answer
Which clause filters groups produced by GROUP BY? [1 mark]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.