SQL 1

Which of the following are components of an SQL statement? (PICK 3)

• SELECT

• FROM

• WHERE

• PROJECT

• CARTESIAN PRODUCT

What does SQL stand for?

• Sample Query Language

• Sequential Query Language

• Sample Query Language

• Structured Query Language

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"

What is the purpose of the * character?

E.g., SELECT * 
FROM celebs;

• It selects new values in the table.

• It only selects fields where values are not empty in the table.

• It selects the leftmost field in the table.

• It selects every field in the table.

Answer explanation

Correct! It allows us to select every column in a table without having to name each one individually.

Which statement is used to extract the table from a database?

• Extract

• Get

• Open

• Select

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select

Using which word allows you to specify that more than one condition must be met in a query?

• Also

• And

• Or

• Where

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

• And

• Maybe

• If

• Or

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

What is the correct order of clauses in a SQL statement?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, FROM, WHERE, ORDER BY

• SELECT, WHERE, FROM, ORDER BY

• WHERE, FROM, SELECT, ORDER BY