With SQL, how do you select a column named "FirstName" from a table named "Persons"?
What is SELECT FirstName FROM Persons
100
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
ANSWER: (FALSE OR TRUE)
What is true
200
statement is used to extract data from a database?
What is SELECT
200
With SQL, how do you select all the columns from a table named "Persons"?
What is SELECT * FROM Persons
200
Which SQL statement is used to return only different values?
What is DISTINCT
300
statement is used to update data in a database
What is UPDATE
300
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
What is SELECT * FROM Persons WHERE FirstName='Peter'
300
Which SQL keyword is used to sort the result-set?
What is ORDER BY
400
statement is used to delete data from a database?
What is DELETE
400
SELECT * FROM Persons WHERE FirstName='Peter'
What is SELECT * FROM Persons WHERE FirstName LIKE 'a%'
400
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
What is SELECT * FROM Persons ORDER BY FirstName DESC
500
statement is used to insert new data in a database?
What is INSERT INTO
500
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
What is SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
500
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
What is UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'