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
Why did you choose the Software Testing Field?
What is performance tuning? What are tools of performance testing?
hai friends i need a general test cases for check box,drop down button and radio butoon can anybody reply me plz..........thanks in advance
hi everybody, iam Adi Durga, i complited my bsc(computers) in 2008.I have experience in finacial and bpo companys(mnc). but iam intersted on s/w role.I have the technical skills c, c++, Oracle 9i and manual testing. But i dont know hoe to strat my career in s/w. Every company offering on financial/bpo side. In this I attended nearly 10 companies,I selected in 8. All those are bpo and finacial, But i cant get any opportunities on s/w side.plz help how to get opportunites on s/w side. Actually I am interested on testing side. But every company offering for only experienced persons. plz help me. this is my mailid.... adi.durga19@gmail.com
what is agile model and spiral maodel?pls explain with an example?
What is test management?
whats main working for tester. and developer, and prject manager.
Explain the difference between alpha testing and beta testing.
can u plz give an example for regression testing with example.
Hi All I want discuss abt Testing tools is any one available online in google chat?
What is function points??????
what are the 3 test tool categories and describe what each can do.
What is 'Account Conditioning'?
Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.
what is the challenging position faced in the testing not in point of management point of view it must be in the point of while testing the application?