SQL Quiz 2

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

• SELECT * FROM Persons;

• SELECT Persons;

• SELECT [all] FROM Persons;

• SELECT *.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 [all] FROM Persons WHERE FirstName='Peter';

• SELECT * FROM Persons WHERE FirstName<>'Peter';

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter';

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

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

• SELECT * FROM Persons WHERE LastName='Jackson';

If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?

• AND

• BOTH

• TRUE

• WHERE

Which of the following is the correct order of keywords for SQL SELECT statements?

• SELECT, FROM, WHERE

• FROM, WHERE, SELECT

• WHERE, FROM, SELECT

• SELECT,WHERE,FROM

The result of an SQL SELECT statement is a(n) ________.

• table

• report

• file

• form

In an SQL SELECT statement querying a single table, the asterisk (*) means that:

• all columns of the table are to be returned.

• all records meeting the full criteria are to be returned.

• all records with even partial criteria met are to be returned.

• None of the given.

To define what columns should be displayed in an SQL SELECT statement:

• use FROM to name the source table(s) and list the columns to be shown after SELECT.

• use USING to name the source table(s) and list the columns to be shown after SELECT.

• use SELECT to name the source table(s) and list the columns to be shown after USING.

• use USING to name the source table(s) and list the columns to be shown after WHERE.

What type of join is needed when you wish to include rows that do not have matching values?

• OUTER JOIN

• INNER JOIN

• OUTER and INNER JOIN

• None of the given

Which of the SQL statements is correct?

• SELECT Username, Password FROM Users

• SELECT Username AND Password FROM Users

• SELECT Username, Password WHERE Username = 'user1'

• None of the given