Back to the full dot-point answer
Northern IrelandDigital TechnologyQuick questions
A2 1 Information Systems
Quick questions on Using databases: SQL and query by example - CCEA A-Level Digital Technology
3short 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 is q1?Show answer
Write an SQL statement to return all columns of the Books table where Genre is 'Science'. [2 marks]
What is q2?Show answer
State which SQL keyword sorts the results of a query. [1 mark]
What is q3?Show answer
Explain why a DELETE statement should normally include a WHERE clause. [2 marks]
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.