Question

Table Employee has 4 records and Table Dept has 3 records in it. Mr. Jain wants to display all information stored in both of these related tables. He forgot to specify equi-join condition in the query. How many rows will get displayed on execution of this query?

Answer 1

12 rows will get displayed on execution of the query

Explanation:

Given: Table Employee has 4 records and Table Dept has 3 records in it.

Mr. Jain wants to display all information stored in both of these related tables.

He forgot to specify equi-join condition in the query.

Find: How many rows will get displayed on execution of this query?

Solution:  

Since Mr. Jain forgot to specify equi-join in his query, a default value will be assigned to the display of the resultant table.

It is the Cartesian product of the two sets of data, so 4 * 3 = 12.