S7 SQL Quiz

What does SQL stand for?

• Strong Question Language

• Structured Query Language 

• Structured Question Language

• Structured Question Layer

Can you tell me which magical SQL spell is used to summon data from a database?

• GET

• SELECT 

• EXTRACT

• OPEN

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

• MODIFY

• UPDATE 

• SAVE

• DELETE

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

• ADD NEW  

• INSERT INTO

• ADD RECORD

• INSERT RECORD

Harper wants to know how to retrieve the first names of all the students from the table named "Persons" using SQL. Can you help Harper out?

With SQL, how do you select all the columns from a table named "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 [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

• SELECT records FROM Persons WHERE FirstName<>'Peter'

Michael and Nora are planning a surprise party for Ava. In SQL, how do you select all the records from a table named "Guests" where the "Name" is "Ava" and the "Relation" is "Friend"?

• SELECT * FROM Guests WHERE Name<>'Ava' AND Relation<>'Friend'

• SELECT * FROM Guests WHERE Name='Ava' AND Relation='Friend'

• SELECT * FROM Guests ON Name='Ava' JOIN Relation='Friend' 

• SELECT Name='Ava', Relation='Friend' FROM Guests

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

• SORT

• SORT BY

• ORDER BY

• ORDER

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

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

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

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