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 O b. 6 rows updated c. O rows updated. d. Makes error Windows but semester 15112-PB 141 SEMESTER_ID START_DAT END_DATE DESCRIPTION 20201 01-OCT-20 31-JAN-21 first semester 20202 01-FEB-21 30-MAY-21 second semester 20203 01-JUL-21 30-AUG-21 summer semester 20191 01-OCT-19 31-JAN-20 first semester 20192 01-FEB-20 30-MAY-20 second semester Courses: COURSE ID COURSE NAME CREDIT HOURS COURSE LEVEL 8444 database 8446 C++ 9442 calculas 1 8442 Operating systems 8433 database lab 3 13 3 3 2 1 Exam resultat STUDENT ID COURSE ID EXAM NAME MAX MARK MARK 20 20 15 2051055 2051055 2051055 2017199 2017199 2017199 8444 first exam 8444 second exam 8444 final exam 8444 final exam 9442 final exam 9442 111st exam 60 30 55 60 60 20 12 13 14 | 15 | 16 Students: ID FULL NAME ADDRESS BD GENDER MAJOR ID REGISTRATION DATE M E 2051055 ahmad ahmad jenin 15-DEC-90 2016130 amal ahmad jenin 10-JUL-00 2017199 abeer sami jerusalim 13-APR-01 2015170 rami yousef nablus 10-JUL-99 2018101 ameer abed ramallah 13-DEC-00 123 123 124 124 125 10-MAR-05 07-SEP-16 12-SEP-17 12-OCT-15 24-AUG-18 M M Registration: STUDENT ID COURSE_ID SEMESTER ID TEACHER_ID RESULT_NUMBER RESULT LETTER 2051055 2051055 2015170 2015170 2015170 8444 9442 8433 8446 8442 20201 20201 20202 20202 20202 15154 78414 15333 98554 98554 95 BO 75 40 F What will be the output of the query: select semester_id from semester minus select semester_id from registration; O a. The semester's ids that no student registered in. O b. The students' ids that never registered. O c. The semester's ids that exists in registration table and not exists in the semester table. O d. The student's ids that are registered. AEO:TE To make a report that contains all information about each student who's full name or address contains 'K': a. select * from students where concat(full_name concat(address)) like '%k%; O b. select * from students where concat(full_name,address) like '%k%'; c. select * from students where full name or address like '%k%'; d. select * from students where full name and address like '%k%