A query To display list of students without students who live in jenin.

a.

select full_name,address from students minus select full_name,address from students where address='jenin';

b.

select full_name,address from students intersect select full_name,address from students where address='jenin';

c.

select full_name,address from students minus select full_name,address from students where address'jenin';

d.

select full_name,address from students union all select full_name,address from students where address='jenin';

The MINUS set operator is used to:

a.

Display the right query result set without the similar result set from the left query.

b.

Display the left query result set without the similar result set from the right query.

c.

Display the right and left result set without the similar result set.

d.

Display the right and left queries result set.

The query that displays all courses in semester 20202 in descending order :

a.

select course_id from courses order by course_id desc intersect select course_id from registration where semester_id=20202 ;

b.

select course_id from courses order by course_id desc intersect select course_id from registration where semester_id=20202 order by course_id desc;

c.

select course_id from courses intersect select course_id from registration where semester_id=20202 order by course_id;

d.

select course_id from courses intersect select course_id from registration where semester_id=20202 order by course_id desc;

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)