Answer Posted / deva
The join between tables with out any conditions specified
results in the cartesian product. Cartesian product will be
equal to the product of number of rows in the tables that
take part in the join.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to run the anonymous block again?
Give the different types of rollback segments.
What is the difference between translate and replace in oracle?
List out the components of logical database structure of oracle database.
Briefly explain what is literal? Give an example where it can be used?
Can group functions be mixed with non-group selection fields?
What are the uses of linked server and explain it in detail?
How to get execution statistics reports on query statements?
How to invoke the original export import utilities?
How to declare a local variable?
What is a subquery?
types of indexes and the rationale behind choosing a particular index for a situation.
What is the Tune Query
How to create a table index?
How do I connect to oracle database?