Interested to Buy Any Domain ? << Click Here >> for more details...
what is a cartition product?
- 4 Answers
- 11683 Views
- I also Faced
- E-Mail Answers
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 |
Explain the use of full option in exp command.
What are the ansi data types supported in oracle?
How to assign values to data fields in record variables?
What is the difference between a primary key & a unique key?
what is dynamic SGA and static SGA
What is the diff between Oracle and SQL Server
What is a Redo Log ?
List the parts of a database trigger.
What are advantages fo Stored Procedures?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
How to drop an index in oracle?
Can a field be used in a report without it appearing in any data group ?
Oracle General 
