Search Header Logo

H starter - N5 SQL revision

Authored by G Alexander-Doyle

Computers

10th Grade

H starter - N5 SQL revision
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

6 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

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.

Evaluate responses using AI:

OFF

Answer explanation

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

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

SQL stands for...

3.

MATCH QUESTION

1 min • 1 pt

Match the operation with the SQL query

Remove record

SELECT FROM

Add record

UPDATE

Search for record(s)

INSERT INTO

Amend record

DELETE

4.

DRAG AND DROP QUESTION

1 min • 1 pt

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

5.

DRAG AND DROP QUESTION

1 min • 1 pt

Complete the DELETE FROM query:

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

table
criteria to be met
records
fields

6.

DRAG AND DROP QUESTION

1 min • 1 pt

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)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?