IS314_Quiz2

Which one of the following is a typical SQL statement?

• Customers(ID, CustomerName, City);

• SELECT * FROM Customers;

• {table: 'Customers', fields: 'ID CustomerName, City'}

True or False.
SQL keywords are case sensitive.

• False
• True

True or False.
SQL can be used to DELETE database records.

• False
• True

What is the correct delimiter to separate the field names in a SQL statement?

SELECT City ____ Address FROM Customers

• ;
• |
• /
• ,

Write a statement that will select the City column from the Customers table.

Write a statement that select all records from customer database where the City column has the value "Berlin".

Consider the following SQL statement:

SELECT * FROM Customers
WHERE Country = 'Mexico' AND PostalCode = 115112

• All records that have a Country field with the value 'Mexico', plus all records with a PostalCode field with the value 115112

• All records that both have a Country field with the value 'Mexico' and a PostalCode field with the value 115112

Use the NOT keyword to select all records where City is NOT "Berlin".

SELECT * FROM Customers _____ ____ ____ = 'Belin';

Select all records where the City column has the value 'Berlin' and the PostalCode column has the value 12209. Database name is Customers.

Select all records where the City column has the value 'Berlin' or 'London'. Database name is Customers.