⟩ Explain Different types of table join?
different types of joins are
-Cartesian Product or Cross Join
-Inner Join
-Equi Join or Natural Join
-Non Equi Join
-Self Join
-Outer Join
-Left Outer Join
-Right Outer Join
-Full Outer Join
Question and Answer:
Home Database Administration
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is dictionary cache?
Which parameter in Storage clause will reduce number of rows per block?
What is meant by free extent?
How will you force database to use particular rollback segment?
How can we organize the tablespaces in Oracle database to have maximum performance?
How will you swap objects into a different table space for an existing database?
What is redo log buffer?
What is meant by recursive hints?
How can we plan storage for very large tables?
How will you estimate the space required by a non-clustered tables?
