Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p
if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately
Can anyone help on this?

Question Posted / mehul.thakur

Answers were Sorted based on User's Feedback



I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p ..

Answer / ankit sinha

equijoin will produce only the common record.
A right outerjoin B will produce all common records with
remaining records from B . The point to be noticed here is A
is right outerjoined to B which means common records from A
as well as remaining records from B

Opposite things happen with A left outerjoin B

Full outer join means common records and remaining records
from both the tables

crossjoin means multiplications
suppose A has 4 records and B has 4 records.
Total output will have 16 records.

Is This Answer Correct ?    7 Yes 0 No

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p ..

Answer / mandayan

not pasible to help u becouse u have to give with data ok

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

Does mysql_real_escape_string prevent sql injection?

0 Answers  

What are the sql aggregate functions?

0 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

What is string join?

0 Answers  

display your age in months?

2 Answers  

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

What is a recursive stored procedure?

0 Answers  

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

What is date functions?

0 Answers  

how to insert the records in particular position

1 Answers  

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

For more SQL PLSQL Interview Questions Click Here
Categories