JOINS AND SUBQUERY
MULTIPLE CHOICE WITH ANSWER
All rows in the first table joined to all rows in the second table is called a cartesian product
__________ returns rows only when there is at least one row from both the tables that matches the join conditions.
c.Non equi join
When two tables are joined using = operator in the join condition it is called as _________
d.Non equi join
Single row subquery return ___________row
SELECT last_name, first_name
WHERE salary IN
WHERE dept_no = 3 OR dept_no = 5);
Which values are displayed?
a. last name and first name of all employees except those working in department 3 or 5
b. last name and first name of all employees with the same salary as employees in department 3 or 5
c. last name and first name of only the employees in department number 3 or 5
d. last name and first name of only the employees whose salary falls in the range of salaries from department 3 or 5