SQL Queries Recap WB 7/12/20

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

What is the template for a Equijoin?

• table1.primaryKey = table2.foreignKey

• owner.primaryKey = pet.ForeignKey

• table1.ownerID = table2.OwnerID

• owner.ownerID = pet.ownerID

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

What Query do we use to change a record?

• SELECT

• UPDATE

• INSERT

• DELETE

What Query do we use to search in a database?

• SELECT

• UPDATE

• DELETE

• INSERT

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

• SELECT

• UPDATE

• INSERT

• DELETE

What type of Query removes a record from a database?

• SELECT

• UPDATE

• DELETE

• INSERT

What Queries can we use the WHERE keyword in?

• SELECT

• UPDATE

• INSERT

• DELETE

What is a record in a database?

• An individual entry in a Database (A row in the table)

• All of the entries in a Database

• The information in a field

• The relationship between 2 table

From what we've learned this week what do you feel the least confident in?