Lab 4

Submitted by Calina Winfield

Form with 10 SQL questions

First Name: *

Last Name: *

SQL Quiz
1. Which SQL statement is used to update data in a database? *
MODIFY
SAVE AS
SAVE
UPDATE

2. What does SQL stand for? *
Structured Question Language
Structured Query Language
Strong Question Language

3. With SQL, how do you select all the columns from a table named "Persons"? *
SELECT [all] FROM Persons
SELECT * FROM Persons
SELECT Persons
SELECT *.Persons

4. Which SQL statement is used to return only different values? *
SELECT DISTINCT
SELECT DIFFERENT
SELECT UNIQUE

5. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table? *
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName
INSERT INTO Persons (LastName) VALUES ('Olsen')

6. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table? *
DELETE ROW FirstName='Peter' FROM Persons
DELETE FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Peter'

7. Which SQL statement is used to insert new data in a database? *
INSERT NEW
ADD RECORD
ADD NEW
INSERT INTO

8. What is the most common type of join? *
INNER JOIN
JOINED TABLE
JOINED
INSIDE JOIN

9. Which operator is used to select values within a range? *
WITHIN
BETWEEN
RANGE

10. Which SQL statement is used to create a database table called 'Customers'? *
CREATE TABLE Customers
CREATE DATABASE TABLE Customers
CREATE DATABASE TAB Customers
CREATE DB Customers

Testing area: for Developers Only

Data collected from the form:
Name:
Answer for Q1:
Answer for Q2:
Answer for Q3:
Answer for Q4:
Answer for Q5:
Answer for Q6:
Answer for Q7:
Answer for Q8:
Answer for Q9:
Answer for Q10: