What is an Equijoin used for?
SQL Queries Recap WB 7/12/20

Quiz
•
Computers
•
9th - 10th Grade
•
Medium
C McLuskie
Used 2+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Similar Resources on Quizizz
10 questions
SQL Programming

Quiz
•
4th Grade - Professio...
15 questions
Chapter 9 - Databases (IGCSE Computer Science)

Quiz
•
9th - 12th Grade
10 questions
Grade 10 FT Quiz1 - Intro to SQL

Quiz
•
10th Grade
10 questions
SQL

Quiz
•
10th Grade
12 questions
sql per 4f

Quiz
•
9th Grade
10 questions
SQL

Quiz
•
9th - 11th Grade
10 questions
Lesson 1 Database Basics

Quiz
•
9th - 11th Grade
10 questions
Access Simplified Quiz

Quiz
•
8th - 12th Grade
Popular Resources on Quizizz
15 questions
Character Analysis

Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
10 questions
American Flag

Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25

Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers

Quiz
•
6th - 8th Grade
Discover more resources for Computers
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Taxes

Quiz
•
9th - 12th Grade
17 questions
Parts of Speech

Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression

Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing

Quiz
•
9th - 12th Grade
10 questions
Identifying equations

Quiz
•
KG - University