What are the type of joins? When do we use Outer and Self joins?
Answer Posted / shivanibehere
For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How will you decide the active and passive nodes?
What is checkpoint process in the sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
explain what is raid and what are different types of raid configurations? : Sql server database administration
Explain system rowset functions?
How to disable triggers using "disable trigger"?
what is a join? : Sql server database administration
Explain what are the events recorded in a transaction log?
What are trace flags?
Explain table valued parameters in sql server? Why tvp used?
Can select statements be used on views in ms sql server?
What is the use of partition by in sql server?
What are triggers in ms sql server?
Ways to improve the performance of a SQL Azure Database?
Explain the disadvantages/limitation of the cursor?