IntroToDatabases W2

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

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT Persons From Persons

What does SQL stand for?

• Structured Query Language

• Strong Question Language

• Structured Question Language

• Strong Query Language

What is SQLite?

• A type of SQL database management system

• A language to access data stored in a relation database

• A programming language for creating data systems

• A language to access data stored in a non-relation database

Which operator is used to select values within a range?

• WITHIN

• RANGE

• ORDER BY

• BETWEEN

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

• SELECT FirstName FROM Persons

• SELECT Persons.FirstName

• SELECT Persons Where FirstName

• SELECT Persons From FirstName

Which SQL statement would return the 'Null' values?

• WHERE Address IS NULL

• WHERE Address IS NOT NULL

• WHERE Address = NULL

• For Each Entry; IF value = 'Null': Selection.append(entry) Return Selection

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' AND LastName='Jackson'

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

• SELECT FirstName='Peter', LastName='Jackson' FROM Persons

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

What would the role of an SQL "Alias" be?

• to search for a specified pattern in a column

• give a table, or a column in a table, a temporary name

• selects values within a given range

• delete existing records in a table

Which Statement would find any values that starts with "a"

• WHERE CustomerName LIKE 'a%'

• WHERE CustomerName LIKE '%a'

• WHERE ContactName LIKE 'a%o'

• WHERE ContactName LIKE 'a'

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included

• ONLY

• UNIQUE

• DISTINCT

• SINGLE