All joins must be based on the equality of values between the joining tables?

List the course number and description of courses with either the course number 20 as a prerequisite or a location of L111.

75. Write the question for the following query:

SELECT first_name, last_name

FROM instructor

WHERE zip NOT IN

(SELECT zip

FROM zipcode)

· List the first and last name of the instructors with zip codes that do not exist in the ZIPCODE table. Instructors with NULL values in the zip column do not show in the result.

The following SQL statement can be expressed differently. Choose the correct equivalent statement.

SELECT course_no, prerequisite

FROM course

WHERE course_no IN

(SELECT course_no

FROM section

WHERE NVL(section_no, 99) > 3) ?

· SELECT DISTINCT c.course_no, prerequisite FROM course c, section s WHERE c.course_no = s.course_no

A DISTINCT must always be used in the top-most SELECT statement of a set operation.?

· False

It is possible to combine data from two tables that do not have a primary key/foreign key relationship into one result using a set operation.?

· True

79. There are no restrictions with using the Oracle outer join operator (+).?

· False

The ANSI join syntax is more flexible than the Oracle outer join syntax.

· True

Self joins are only used for tables with recursive relationships.

· False

82. Oracle supports a full outer join using two outer join operators (+).

· False

All joins must be based on the equality of values between the joining tables?

· False