H starter - N5 SQL revision

One type of query we covered at level 5 was the SELECT FROM query. State the other three types of SQL query you learned about at National 5.

Answer explanation

At N5 level we learned about SELCT FROM, DELETE, INSERT INTO and UPDATE queries.

SQL stands for...

Match the operation with the SQL query

• Remove record

• SELECT FROM

• Add record

• UPDATE

• Search for record(s)

• INSERT INTO

• Amend record

• DELETE

Complete the SELECT FROM query:

SELECT​ (a)   FROM​ (b)   WHERE​ (c)   ORDER BY​ (d)  

• fields to be displayed
• table(s)
• search criteria
• fields to be sorted

Complete the DELETE FROM query:

DELETE FROM​ (a)   WHERE​ (b)   ;

• table
• criteria to be met
• records
• fields

Complete the UPDATE query:

UPDATE (a)   SET ​ (b)   WHERE​ (c)   ;

• table
• criteria to be met
• field values to be changed
• field values to be retained
• record(s)