QUESTION 24

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

   		0
   		1
   		3
   		5
   		8

1.67 points

QUESTION 25

1. How many rows will the following query return? SELECT * FROM doctor WHERE specid = 'ANE';

   		1
   		2
   		3
   		4
   		5

1.67 points

QUESTION 26

1. How many rows will the following query return? SELECT * FROM specialty WHERE specid = 'ANE';

   		1
   		2
   		3
   		4
   		5

1.67 points

QUESTION 27

1. What will be the result of the following query? SELECT sum(noofpatients) FROM doctor WHERE specid = 'SUR';

   		2
   		20
   		40
   		70
   		100

1.67 points

QUESTION 28

1. How many rows will the following query return? SELECT * FROM doctor, specialty WHERE doctor.specid = specialty.specid;

   		0
   		1
   		3
   		5
   		8

1.67 points

QUESTION 29

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

   		number 1
   		number 3
   		numbers 2 and 1
   		number 5
   		numbers 2, 1, and 2

1.67 points

QUESTION 30

1. What will be the result of the following query? SELECT docname FROM doctor WHERE noofpatients = (SELECT max(noofpatients) FROM doctor);

   		Jill
   		30
   		Linda
   		Lisa
   		RAD

DOCTOR DocID 111 222 DocName NoOfPatients SpecID Jill 20 SUR Linda 20 SUR Lisa 30 RAD Sue 15 ANE Lola 15 ANE 333 555 SPECIALTY SpecID SUR RAD ANE SpecName Surgery Radiology Anesthesiology