Name: _______________________________

Deadline to submit Midterm Exam Results is Sunday 05/12/2013 – No late submission will be accepted for credit.

Please insert your answer on the line (left of each question) in UPPER CASE letter.
Example: ___A____. Only answers provided on the assigned line will be checked for credit.
.
Provide your answer for all 20 questions on this original copy of the test.

Each question is for 5 points for total of 100 points.

Identify the choice that best completes the statement or answers the question.

____ 1. To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.
a. SELECT c. WHERE b. FROM d. HAVING

____ 2. If a column alias contains a blank space, it must be enclosed in ____.
a. single quotation marks (‘ ‘) c. asterisks (* *) b. double quotation marks (” “) d. percent signs (% %)

Contents of the PUBLISHER table

____ 3. Based on the contents of the PUBLISHER table, which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?
a. UPDATE publisher REPLACE phone WITH ‘800-714-8321’
WHERE pubid = 1; b. UPDATE publisher REPLACE phone = ‘800-714-8321’
WHERE pubid = 1; c. UPDATE publisher SET phone = ‘800-714-8321’
WHERE pubid = 1; d. none of the above

Contents of the BOOKS table

____ 4. Based upon the contents of the BOOKS table, which of the following is a valid SQL statement?
a. SELECT “The retail price of ” || title || ” is ” retail FROM books; b. SELECT * || is currently in our inventory FROM books; c. SELECT title, || retail “Price” FROM books; d. SELECT isbn || CHR(10) || title FROM books;

____ 5. Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?
a. SELECT * FROM books; b. SELECT title, retail+retail FROM books; c. SELECT title, retail^2…