You are joining table A and table B, both of which are not sorted on the same join columns. What type of join will be performed?A.FULL OUTER JOINB.MERGE JOINC.HASH JOIND.NATURAL JOIN

The type of join that will be performed when joining table A and table B, both of which are not sorted on the same join columns, is C. HASH JOIN.

Here's why:

A. FULL OUTER JOIN: This type of join returns all those records which either have a match in either table. The sorting of columns doesn't affect this type of join.

B. MERGE JOIN: This type of join is used when the join columns in the input tables are sorted. Since the tables in the question are not sorted on the same join columns, this type of join cannot be used.

C. HASH JOIN: This type of join is used when the join columns in the input tables are not sorted. It uses a hashing algorithm to join tables. Since the tables in the question are not sorted on the same join columns, this type of join will be used.

D. NATURAL JOIN: This type of join is a type of equi-join where the column being joined is implicitly based on the column names. The sorting of columns doesn't affect this type of join.