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 can you insert null values in a column while inserting the data?
Explain the properties of sub-query in sql server?
What is a trigger? Why we need it?
Tell me the phases a transaction has to undergo?
What are dml triggers and types of dml triggers?
Can you leave a union at any time?
Tell me in brief how sql server enhances scalability of the database system?
Do you know the different ddl commands in sql?
Describe triggers features and limitations?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a trace frag? Where do we use it?
Where can you add custom error messages to sql server?
What is the filtered index?
Do you know what is xpath?
What is the sql server agent?