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
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
Explain severity with example and expalin each example?
What kind of input do we need from the end user to begin proper testing?
Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.
Diffrernce between client server testing and web server testing.
what is the difference between Risk based and Requirement based testing???
hi friends .......... from srs to signoff what r the tests the testing team will conduct either sequentially or parallel pls advice thanks in advance
can u merge 10GUI map files into a single GUI map file in winrunner?
What were the major challenges u faced while testing
Explain Single View Testing ?
What is the difference between baseline and traceability matrix?
Changes and enhancements to system?
how to create automation frame work ?
How the application is launched to the production environment?
1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?
