using this scheme answer:

A report that displays the id,full_name and major_id for all students that have the same major_id as the student 'rami yousef'.

a.

select Major_id,full_name from students where major_id = (select major_id from students where full_name like 'rami yousef');

b.

select Major_id,full_name from students where id = (select id from students where full_name like 'rami yousef');

c.

select Major_id,full_name from students where (select major_id from students where full_name like 'rami yousef');

d.

select major_id from students where full_name like 'rami yousef';

2.

When trying to execute these queries : insert into courses values (8445,'computer organization',3,3); savepoint A ; insert into courses values (8466,'networks programming',3,5); savepoint B ; insert into courses values (9443,'calculus 2',3,1); commit; rollback to A ; which of the following is true:

a.

calculus 2 course added to table courses.

b.

computer organization course added to table courses.

c.

3 rows added to table acourses and Error at line : rollback to A; .

d.

2 rows added to table courses and error at line : commit;

3)

A report that Display info about students who regsitered in the semester 20201.

a.

SELECT r.student_id, s.semester_id from semester s join registration r where s.semester_id = 20201;

b.

SELECT r.student_id, s.semester_id from semester s join registration r on s.semester_id = r.semester_id where s.semester_id = 20201;

c.

SELECT r.student_id, s.semester_id from semester s join registration r on s.semester_id = r.semester_id;

d.

None of the above.

Exam_results Majors Major_id: number(3) Major_name: varchar2(50) Department_name: varchar2(50) Faculty:varchar2(50) Student_id: number(10) Course_id: number(10) Exam_name: varchar2(50) Max_mark: number(5,2) Mark:number(5,2) courses Students Course_id: number(10) Course_name:varchar21 100) Credit_hours:number(2) Course_level:number(2) Teachers Teacher_id: number(5) Teacher_name:varchar2 (50) Department_name:varc har2(10) ID: Number(10) Full_name: Varchar2(50) Address: varchar2(50) Bd:date Gender: char(1) Major_id: number(3) Registration_date: date Semester Semester_id: number(5) Start_date: date End_date: date Description:varchar2(50) Registration Student_id: number(10) Course_id: number(10) Semester_id: number(5) Teacher_id: number(5) Result_number: number(5,2) Result_letter: char(1)