17-

To change the department name of teacher 98554 and make it as the department name of teacher 15333 ;

a.

Update teachers set department_name = (select department_name from teachers where teacher_id = 15333) ;

b.

Update teachers set department_name = (select department_name from teachers where teacher_id = 98554) where teacher_id =15333;

c.

Update teachers set department_name = select department_name from teachers where teacher_id = 15333 where teacher_id = 98554;

d.

Update teachers set department_name = (select department_name from teachers where teacher_id = 15333) where teacher_id = 98554;

18-

Based on the data inserted in the university database given, how many rows will be updated after executing the following query: update exam_results set mark=max_mark/2 where student_id in (select student_id from registration where semester_id=20202) and exam_name='final exam';

a.

3 rows updated

b.

6 rows updated

c.

0 rows updated.

d.

Makes error

19-

The query: select count(id) from students join majors using(major_id) group by faculty; displays:

a.

Number of students for each faculty.

b.

Number of students in the students table.

c.

Makes error.

d.

No results.