GCSE 2.2 SQL

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

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

• SELECT

• SHOW

• FROM

• WHERE

The SQL command to choose which tables the data for the query will be taken from

• SELECT
• WHERE
• FROM
• SHOW

The SQL command which sets conditions for the rows or columns to be shown in the query output

• WHERE
• SELECT
• FROM
• WHEN

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

• SELECT *.Persons

• SELECT Persons

• SELECT [all] FROM 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 [all] FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

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

• SELECT * FROM Persons WHERE FirstName='Peter'

What does SQL stand for?

• Structured Query Language

• Strong Question Language

• Structured Question Language

• Strong Query Language

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

• EXTRACT FirstName FROM Persons

• SELECT Persons.FirstName

• SELECT FirstName FROM 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" starts with an "a"?

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

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

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

• SELECT * FROM Persons WHERE FirstName='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