SQL Quiz

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

• SELECT

• GET

• EXTRACT

• OPEN

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

• DELETE

• COLLAPSE

• DROP

• REMOVE

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

• MODIFY

• SAVE AS

• SAVE

• UPDATE

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

• SELECT FirstName FROM Persons

• SELECT Persons.FirstName

• SELECT Persons Where FirstName

• SELECT Persons From FirstName

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

• ADD RECORD

• INSERT INTO

• ADD NEW

• INSERT NEW

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

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT Persons From Persons

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'

• SELECT * FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

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

• False

• Both A and B

• None of these

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'

• SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

• SELECT FirstName='Peter', LastName='Jackson' FROM Persons

• SELECT*FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

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

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

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

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

• INSERT INTO Persons VALUES