SQL Queries Recap WB 7/12/20

SQL Queries Recap WB 7/12/20

9th - 10th Grade

10 Qs

quiz-placeholder

Similar activities

Computer Science Career

Computer Science Career

9th - 12th Grade

15 Qs

Database Basics

Database Basics

7th - 9th Grade

10 Qs

Złożone zapytania SELECT 06

Złożone zapytania SELECT 06

1st Grade - Professional Development

10 Qs

Database P4

Database P4

10th Grade

12 Qs

Database Concept

Database Concept

9th - 12th Grade

10 Qs

Database (Yr9: L3)

Database (Yr9: L3)

7th - 9th Grade

12 Qs

Access - Lesson 13

Access - Lesson 13

9th - 12th Grade

10 Qs

S3 Databases Knowledge Check

S3 Databases Knowledge Check

2nd - 9th Grade

15 Qs

SQL Queries Recap WB 7/12/20

SQL Queries Recap WB 7/12/20

Assessment

Quiz

Computers

9th - 10th Grade

Medium

Created by

C McLuskie

Used 2+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an Equijoin used for?

To stop records with the same field value from appearing more than once in the same table

To allow searches across multiple tables

To copy over field data to another record

To delete a record

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the template for a Equijoin?

table1.primaryKey = table2.foreignKey

owner.primaryKey = pet.ForeignKey

table1.ownerID = table2.OwnerID

owner.ownerID = pet.ownerID

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which query would return only the fields DesignerID and Designer?

SELECT * FROM Designers

SELECT DesignerID, Name FROM Designers

SELECT DesignerID AND Designer FROM Designers

SELECT DesignerID, Designer FROM Designers

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What Query do we use to change a record?

SELECT

UPDATE

INSERT

DELETE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What Query do we use to search in a database?

SELECT

UPDATE

DELETE

INSERT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of query will add a record to a Database?

SELECT

UPDATE

INSERT

DELETE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of Query removes a record from a database?

SELECT

UPDATE

DELETE

INSERT

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?