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
what r the 5 major defects that u found in ur shopping related project?
What types of documentation are used in qa?
What is concurrent user hits in load testing?
In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?
write 5 critical test cases on product payment form on flipkart.com?
MS Paint
Test Cases For Router&Switch
How will u decide test data to see that evey feature is thoroughly tested
Do you know anything about Set Top Boxes?
HOW TO CREATE SRS REVIEW REPORT TO PL?
Do submit teststrategy to customer if yes at what time
Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?
Write the test cases for file transfer from one user to other from Google Drive/drop box?
What exactly you do as a Configuration controller?
how we write test cases to brs,srs,hlds,llds
