SQL Quiz

Question 1:

What does SQL stand for?

Structured Query Language Correct answer

Strong Question Language

Question 2:

Which SQL statement is used to extract data from a database?

SELECT Correct answer

OPEN

GET

EXTRACT

Question 3:

Which SQL statement is used to update data in a database?

UPDATE Correct answer

SAVE AS

SAVE

MODIFY

Question 4:

Which SQL statement is used to delete data from a database?

DELETE Correct answer

COLLAPSE

REMOVE

Question 5:

Which SQL statement is used to insert new data in a database?

INSERT INTO Correct answer

ADD RECORD

INSERT NEW

ADD NEW

Question 6:

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT FirstName FROM Persons Correct answer

EXTRACT FirstName FROM Persons

SELECT Persons.FirstName

Question 7:

With SQL, how do you select all the columns from a table named "Persons"?

SELECT * FROM Persons Correct answer

SELECT Persons

SELECT [all] FROM Persons

SELECT *.Persons

Question 8:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter' Correct answer

Question 9:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%' Correct answer

Question 10:

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

True Correct answer

False

Question 11:

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' Correct answer

Question 12:

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' Correct answer

Question 13:

Which SQL statement is used to return only different values?

SELECT DISTINCT Correct answer

SELECT DIFFERENT

Question 14:

Which SQL keyword is used to sort the result-set?

SORT BY

ORDER

ORDER BY Correct answer

Question 15:

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC Correct answer

Question 16:

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson') Correct answer

INSERT ('Jimmy', 'Jackson') INTO Persons

Question 17:

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons (LastName) VALUES ('Olsen') Correct answer

INSERT INTO Persons ('Olsen') INTO LastName

INSERT ('Olsen') INTO Persons (LastName)

Question 18:

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' Correct answer

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

Question 19:

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName = 'Peter' Correct answer

Question 20:

With SQL, how can you return the number of records in the "Persons" table?

SELECT LEN(*) FROM Persons

SELECT COUNT(*) FROM Persons Correct answer

SELECT COLUMNS(*) FROM Persons

Question 21:

What is the most common type of join?

INNER JOIN Correct answer

JOINED TABLE

JOINED

INSIDE JOIN

Question 22:

Which operator is used to select values within a range?

WITHIN

BETWEEN Correct answer

Question 23:

The NOT NULL constraint enforces a column to not accept NULL values.

True Correct answer

Question 24:

Which operator is used to search for a specified pattern in a column?

FROM

LIKE Correct answer

Question 25:

Which SQL statement is used to create a database table called 'Customers'?

CREATE TABLE Customers Correct answer

CREATE DATABASE TAB Customers

CREATE DB Customers

Pages