what is a cartition product?
Answers were Sorted based on User's Feedback
Answer / guneetinder singh
it is the resultant relation from the two relation in the
sense that every element of first column in first table is
linked with every element of second relations first column.
E.G.
A={1,2}
b={3,4}
Cartesian product is = {(1,3)(1,4)(2,3)(2,4)}
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / patilshashi
a query with no where clause in it, it will return no of
rows of first table multiplied by no of rows of second table
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ron
Cartesian product includes rows from all the tables where
there is no specific criteria to join on.
it does not necessarily mean that there is no where clause
it can have a where clause where you filter data set from
table a, table b, c... and then join these tables to give
you the product of the join.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sony
If A and B are two sets the AxB is the cartetion product of
A and B
Is This Answer Correct ? | 1 Yes | 0 No |
Differentiate between pre-select and pre-query?
what happened to the global index when I truncate the data in one of the partition?
What are the limitations oracle database 10g xe?
What is the implicit cursor in oracle?
a query to select maxmun 3 salaries of employee table
What is Virtual Private Database in Oracle?
How to call a stored function with parameters?
How to handle a single quote in oracle sql?
What is the quickest way to export a table to a flat file?
20. Using a set operator, display the client number of all clients who have never placed an order.
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
Name the three major set of files on disk that compose a database in Oracle?