Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shankar
2 types:
1. Inner Join
2. Outer Join
3. Cross Join
1. Inner Join: Inner Join displays matched rows.
2. Outer Join: Outer Join displays matched rows as well as
unmatched rows. Outer Joins again classifed into 3 types.
2a. Left Outer Join: Matched rows as well as left table
unmatched rows.
2b. Right Outer Join: Matched rows as well as right table
unmatched rows.
2c. Full Outer Join: Matched rows as well as left table
unmatched rows and right table unmatched rows.
3. Cross Join: It will display the cartegion product of the
tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Unix question: 1)command to print a list of files containing a particular word. 2) what does a .profile mean. 3) what is a file server? 4) Command to move towards left in vi editor explain grep and find commands using example.
In a systen design to work out the tax to be paid: An employee has Rs 4000 of salary tax free. the next Rs 1500 is taxed at 10% , the next Rs 28000 is taxed at 22% , any further amount is taxed at 40% , the nearest whole Rs, which of these is a valid boundary value analysis test case ???? a)Rs 1500 b)Rs 32001 c)Rs 33501 d) Rs 28000.
Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.
how to test ecg machine?
what r u r responsibilities in current project
I want to know about satyam manual testing questions
How can I use bugzilla in my company to track a bug and to allow the client to see the bug report online throughbugzilla. Please explain in detail. I am really need this.
In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?
Difference between Stakeholder and Relevant Stakeholder?
1.What is configuration Management? 2. Explain Impact Analysis 3. Explain Peer Review 4. what i kickoff phase of Formal Review. 5. Whatv are the phases of fundamental test process. 6. what is state transition testing. 7. what is LCSAJ 8. Test conditions are derived from where?
.In languages testing, what is the fixed part and changing part?
What are bug leakage and bug release?
Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com
How many types of api testing are there?
can anybody tell me what is release process of company? release note?
