SQL

Front

What does SQL stand for?

Back

Structured Query Language

Front

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

Back

SELECT

Front

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

Back

DELETE

Front

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

Back

UPDATE

Front

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

Back

SELECT FirstName FROM Persons

Front

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

Back

INSERT INTO

Front

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

Back

SELECT * FROM Persons

Front

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

Back

SELECT * FROM Persons WHERE FirstName='Peter'

Front

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

Back

True

Front

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

Back

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