QUESTION 31

1. How many rows will the following query return? SELECT * FROM enrollment;

   		0
   		1
   		2
   		3
   		4

1.67 points

QUESTION 32

1. How many rows will the following query return? SELECT courseid FROM enrollment;

   		0
   		1
   		2
   		3
   		4

1.67 points

QUESTION 33

1. How many rows will the following query return? SELECT * FROM enrollment WHERE courseid = PMG;

   		0
   		1
   		2
   		3
   		4

1.67 points

QUESTION 34

1. How many rows will the following query return? SELECT * FROM enrollment WHERE enrollment.courseid = course.courseid;

   		0
   		1
   		2
   		3
   		4

1.67 points

QUESTION 35

1. What will be the result of the following query? SELECT count(*) FROM enrollment GROUP BY courseid;

   		number 1
   		number 3
   		numbers 3 and 1
   		number 4
   		numbers 4, 3, and 1

1.67 points

QUESTION 36

1. How many rows will the following query return? SELECT courseid, count(*) FROM enrollment GROUP BY courseid;

   		0
   		1
   		2
   		3
   		4

ENROLLMENT EmpID EmpName EmpName CourseID 111 Joe AMG 222 Bob AMG 333 Lisa PMG Sue AMG COURSE CourseID AMG PMG CourseName Anger Management Project Management