Indian Space Research Organisation fresher Interview Questions and Answers

Cartesian join is a type of join where every row of one table is combined with every row of another table.

• Also known as cross join

• Does not require any matching condition

• Results in a large number of rows

• Syntax: SELECT * FROM table1 CROSS JOIN table2

• Example: combining a list of products with a list of customers

Query to create a table

• Use CREATE TABLE statement

• Specify table name and column names with data types

• Add constraints if required