SQL

Question 1

ALL

Answer 1

*

Question 2

ANY or no characters

Answer 2

%

Question 3

Exactly one character

Answer 3

_ (underscore)

Question 4

Select every record from the table

Answer 4

SELECT * FROM table

Question 5

Select every record from the table with the name attribute “Bob”

Answer 5

SELECT name(comma) surname FROM table WHERE name = “Bob”

Question 6

Select every record from the table with the name attribute starting with “B”

Answer 6

SELECT * FROM table WHERE name LIKE “B%”

Question 7

Deletes the table

Answer 7

DROP TABLE table

Question 8

Delete the records with the name attribute “Bob”

Answer 8

DELETE FROM table WHERE name = “Bob”

Question 9

Selects distinct records

Answer 9

SELECT DISTINCT

Question 10

Insert a record into a table

Answer 10

INSERT INTO Customers (Name (comma) Surname) VALUES (“Bob” (comma) “Smith”)

Question 11

Select ProductID from Orders table and Address from Customers table where shipped is false

Answer 11

SELECT Orders.ProductID (comma) Customers.Address FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID Where Shipped = “False”

Question 12

Update the name of Bob to John in the Customers Table

Answer 12

UPDATE Customers SET Name = “John” Where Name = “Bob”