33-

We can use the following command to give a value 'Graduated' to a variable named Status

a.

VARCHAR Status= 'Graduated'

b.

DEFINE Status 'Graduated'

c.

UNDEFINE Status

d.

DEFINE Status = 'Graduated'

34-

The INTERSECT set operator is used to:

a.

Display the similar result sets between 2 queries.

b.

Display the left and right non-similar result sets between 2 queries.

c.

Display all the similar and non-similar result sets between 2 queries.

d.

Display the left non-similar result set between 2 queries.

35-

Query that displays all courses after c++ (level 1) :

a.

select * from courses where course_level > (select course_name from courses where course_level = 1);

b.

select * from courses where course_level >(select course_level from courses where course_name = 'c++');

c.

select * from courses where course_level > any (select course_name from courses where course_level = 1);

d.

select * from courses where course_level in (select course_level from courses where course_name = 'c++');

36-

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.