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
What is pesticide paradox? How to overcome it?
What is the difference between Functional testing and Unit Functionality testing?
What are the Important test scenarios which can be used for testing a web site?
Tell me agile process in your company
Should testing be done only after the build and execution phases are complete?
hi friends, i have completed course and project on insurance domain in mindq testing institution...can any working employee please tell me ,which notes( testing subject notes,project notes)i have to prefer first.i was studied both notes and getting confussion.one of my friend got job throughly only project notes and said that project notes is enough to get job.in which way ,i have to prepare interview( which important topics first ), if you are follow any strategy to interview purpose,pls send me important topics list.
What is system level testing?
what the purpose of requirement phase
Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?
*) Internal review defect gets detected… 1) During peer review. 2) By the own stuff member onsite/offshore. 3) During Informal review process. 4) None of these 5) All of these
What is the difference between white box, black box, and gray box testing?
What is the main use of preparing a traceability matrix?
What are the different test techniques used in functional testing?
aplitue questions will be based on wich type ?
Describe a past experience with implementing a test harness in the development of software.
