1. How many records will be retrieved by the following query on tables AGENT and AREA?

SELECT *

FROM agent ag, area a

WHERE ag.agentarea = a.areaid;

0

5

4 (not correct)

3

2. ENROLLMENT AND COURSE

Observe the ENROLLMENT AND COURSE database:

ENROLLMENT

EmpID	EmpName	CourseID
111	Joe	AMG
222	Bob	AMG
333	Lisa	PMG
444	Sue	AMG

COURSE

CourseID	CourseName
AMG	Anger Management
PMG	Project Management

This database will be used for the following questions citing tables ENROLLMENT and COURSE.

What will be the result of the following query?

SELECT count(*) FROM enrollment GROUP BY courseid;

1,3

1

4 (not correct)

3

3. BEVERAGE

Observe the table BEVERAGE:

BEVERAGE

BevID BevName BevType

B1 ZenMaster Tea

B2 LillyChai Tea

B3 AwakeBrew Coffee

B4 MintMild Tea

B5 MintBlast Tea

B6 RoastPal Coffee

Which of the following queries on table BEVERAGE will return number 2 as a result?

None of the above

SELECT COUNT(*) FROM beverage;

SELECT COUNT(bevname) FROM beverage; (not correct)

SELECT COUNT(bevtype) FROM beverage;

4. Which of the following statements would be used to drop a column from the table?

INSERT INTO

ALTER TABLE

DROP TABLE (not correct)

CREATE TABLE