SQL QUIZ

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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

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

Structured Query Language

What does SQL stand for?

DELETE

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

SELECT

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

SELECT DISTINCT

Which SQL statement is used to return only different values?

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

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

SELECT FirstName FROM Persons

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

SELECT * FROM Persons

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

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

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'

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

Ensembles d'études connexes