SQL Queries Recap WB 7/12/20

SQL Queries Recap WB 7/12/20

9th - 10th Grade

10 Qs

quiz-placeholder

Similar activities

SQL

SQL

10th - 12th Grade

11 Qs

AQA GCSE Databases and SQL

AQA GCSE Databases and SQL

9th - 12th Grade

14 Qs

Manipulating Relational Databases

Manipulating Relational Databases

10th - 12th Grade

10 Qs

SQL and databases

SQL and databases

KG - 12th Grade

10 Qs

Database-Quiz-G11

Database-Quiz-G11

9th - 11th Grade

15 Qs

Unit 6 Quiz Prep

Unit 6 Quiz Prep

9th - 12th Grade

15 Qs

Advanced SQL

Advanced SQL

KG - University

10 Qs

GCSE Databases & SQL

GCSE Databases & SQL

9th - 11th Grade

14 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?