JOINS AND SUBQUERY

MULTIPLE CHOICE WITH ANSWER

1)

All rows in the first table joined to all rows in the second table is called a cartesian product

True

False

2)

__________ returns rows only when there is at least one row from both the tables that matches the join conditions.

a.Outer join

b.Self join

c.Non equi join

d.Equi join

3)

When two tables are joined using = operator in the join condition it is called as _________

a.Outer join

b.equi join

c.Self join

d.Non equi join

4)

Single row subquery return ___________row

a.Many

b.Three

c.one

d.Two

5)

SELECT last_name, first_name

FROM employee

WHERE salary IN

(SELECT salary

FROM employee

WHERE dept_no = 3 OR dept_no = 5);

Which values are displayed?

Select one:

 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

  • Loginhackers Blogger
  • Contact us via Twitter Loginhackers
  • Contact us via Instagram
  • loginhackers facebook contact id

Free Premium | Spotify premium for free | Grammarly free premium | Netflix free accounts | Netflix mod | Spotify mod | Hotstar mod | Spotify premium mod apk | free amazon prime account