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
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
Similar Resources on Wayground
10 questions
1. Flat File & Relational Databases

Quiz
•
10th Grade
15 questions
CS IGCSE Unit 3. Databases

Quiz
•
10th Grade
15 questions
Databases

Quiz
•
10th Grade - University
10 questions
Struktur Database

Quiz
•
9th - 12th Grade
15 questions
Preguntas sobre SQL

Quiz
•
9th - 12th Grade
10 questions
DBMS- CLASS8 CBSE

Quiz
•
7th - 10th Grade
10 questions
Spring MVC

Quiz
•
10th Grade
14 questions
ASK (SQL) Tingkatan 3

Quiz
•
9th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
Proper Keyboarding Techniques

Interactive video
•
6th - 10th Grade
14 questions
Inputs and Outputs: Computer Science Intro

Lesson
•
5th - 9th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems

Interactive video
•
7th - 12th Grade
29 questions
AP CSP Unit 2 Review (Code.org)

Quiz
•
10th - 12th Grade