Structured Query Language
Joins
Q.

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

EMPLOYEES

EMPLOYEE_ID NUMBER
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
LAST_NAME VARCHAR2(25)

DEPARTMENTS

DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
DEPARTMENT_NAME VARCHAR2(35)
LOCATION_ID NUMBER

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?
A.  

 SELECT last_name, department_name, location_id FROM employees , departments ;

 B.  

SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;

 C.  

SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;

 D.  

SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
Similar Questions
1.

How many join types in join condition
A.  

2

 B.  

3

 C.  

4

 D.  

5
2.

Which are the join types in join condition
A.  

Cross join

 B.  

Natural join

 C.  

Join with USING clause

 D.  

All of the mentioned
3.

Which join refers to join records from the write table that have no matching key in the left table are include in the result set
A.  

Left outer join

 B.  

Right outer join

 C.  

Full outer join

 D.  

None of the above
4.

 Relation R1 has 10 tuples and 5 attributes. Relation R2 has 0 tuples and 7 attributes. When a CROSS JOIN is achieved between R1 and R2, how many tuples would the resultant set have?
A.  

28

 B.  

10

 C.  

0

 D.  

35
5.

Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition?
A.  

Outer Join

 B.  

Cross Join

 C.  

Inner Join

 D.  

None of the above
6.

Which of the following conditions has to be satisfied for INNER JOIN to work ?
A.  

Columns used for joining must have same name

 B.  

Columns used for joining can have same or different name

 C.  

Columns used for joining must have different names

 D.  

Columns used for joining must have different names
7.

Which join is equivalent to Cartesian Product?
A.  

INNER JOIN

 B.  

OUTER JOIN

 C.  

CROSS JOIN

 D.  

NATURAL JOIN
8.

Which of the following statements are False?
A.  

RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed

 B.  

FULL OUTER JOIN is same as CROSS JOIN

 C.  

SELF JOIN is a special type of OUTER JOIN

 D.  

Both B and C
9.

To specify a normal join, using the keyword inner is?
A.  

Mandatory

 B.  

Optional

 C.  

Independent

 D.  

Free
10.

Left outer join preserves tuples only in the relation named before
A.  

Right outer join operation

 B.  

Right inner join operation

 C.  

Left inner join operation

 D.  

Left outer join operation
STRUCTURED QUERY LANGUAGE TOPICS