1.) Which is not a correct statement

Spin off tables are snapshots of data at the time of creation. Does not offer real-time view of data.

All are correct statements

A spin-off table is an actual table where a view is simply a stored SELECT

Both spin-off tables and views offer security

2.) Based on the following statement, which data would not be retrieved?

SELECT * FROM Customers where City LIKE %mesa%

All will be returned

Lakme Salon

Mesa

Grand Mesa

Mesa Verde

3.) Adds some conditional logic (similar to If/Then) to column contents

WHILE

CASE

LIKE

IN

4.) This is a valid statement:

SELECT * FROM orders WHERE State=WA AND State=OR AND State= ID

True

False

5.) SELECT Name, Address, City, Zip, Phone INTO CA-Customers FROM Customers WHERE State=CA ORDER BY Name

will copy California name, address, zip and Phones into an existing table named CA-Customers.

True

False