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 meant by application server and its functions?
how to write manual testcases for download the files from the template. for example:from product cost enddate
Can you explain random/monkey testing?
what is the difference between Desktop testing,Client/server testing and webapplication testing
hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks
How to do security implementation for any URL??
can any one post the format of tracebility martrix Plz...... Maid Id: sandhya.shyamala@yahoo.com
What is a critical bug?
1) how will you do validation testing in combo box ? (2)Suppose user does not want maximum length validation message, but when tester inserts data in textbox and it gets truncated, how will you resolve this issue ? (3)if a user inserts maximum number in quantity textbox in a PHP based web application then what result will show?
write the test senario on opening door in the flow diagram format
!what are the entry criteria for antomation testing ?
For any web application, what are the possible login features that should be tested?
what are the 3 test tool categories and describe what each can do.
what is scrum how with ex?
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 ?.