Working with JOINS Using the ssh Oracle database 11g 2 How m

Working with JOINS “Using the ssh, Oracle database 11g”

2- How many rows are returned in a Cartesian join between one table having 5 records and a second table having 10 records?

3- What is the purpose of a column qualifier? When are you required to use one?

2.Cartesian joins:

1.It is the product of two tables involved.

2.cross join should not have an ON clause.

3.it removes the null values(undefined values).remaining all types of joins are unable to filter the null values.

Given Table 1 =5 Records

Table 2=10 Records

=5*10

=50 Rows

3) Purpose of column qualifier:it is mainly to recognize the table holding the referenced column.

A column qualifier should be utilized the place where great extent than a single table with referenced column to eliminate the ambiguity error.