Database

What does SQL stand for?

• Structured Question Language

• Strong Question Language

• Structured Query Language

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

• OPEN

• SELECT

• EXTRACT

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

• SELECT Persons.FirstName

• EXTRACT FirstName FROM Persons

• SELECT FirstName FROM Persons

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

• SELECT Persons

• SELECT *.Persons

• SELECT * 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='Peter'

• SELECT [all] 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" starts with an "a"?

• SELECT * FROM Persons WHERE FirstName LIKE 'a%'

• SELECT * FROM Persons WHERE FirstName='a'

• SELECT * FROM Persons WHERE FirstName LIKE '%a'

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

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 FirstName='Peter', LastName='Jackson' FROM Persons

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

• 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 "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

• SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

• SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

• SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

Which SQL statement is used to return only different values?

• SELECT DIFFERENT

• SELECT UNIQUE

• SELECT DISTINCT