Multiple choice

Assume there are 20 rows in the STUDENTS table and 5 rows in BRANCH table. Take a look at the Query below.

STUDENT Table has columns - STUDENT_ID, STUDENT_NAME, BR_ID, AGE, MARKS BRANCH Table has columns - BRANCH_ID, BRANCH_NAME

SELECT STUDENT_ID, STUDENT_NAME, BRANCH_ID, BRANCH_NAME FROM STUDENTS, BRANCH

What is the name of the join used in the above Query.

  1. INNER JOIN

  2. OUTER JOIN

  3. NORMAL JOIN

  4. CROSS JOIN

  5. SELF JOIN
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Look at the Query: Query has 2 different tables STUDENTS and BRANCH. The Query does not have any JOIN predicate, i.e. it evaluates to TRUE for every in tables. It results in all possible combinations of rows from both the tables. This kind of JOIN is called CROSS JOIN or CARTESIAN JOIN.

Keep practicing — related questions