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

there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?

Question Posted / deshpandesam123

Answers were Sorted based on User's Feedback



there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / santosh pashte

It is concept of CROSS JOIN..

It will display 5 * 2 = 10 rows

Is This Answer Correct ?    41 Yes 4 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / subbu

It is a cross join

So, the output is 5*2=10

Is This Answer Correct ?    13 Yes 0 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / manda

It gives a cartesian product or a cross product.

Is This Answer Correct ?    11 Yes 1 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / mubin ahmad

select * from a,bwill be the out put in 10 rows

Is This Answer Correct ?    11 Yes 2 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / dharmendra singh

Concept of cross join
the result will be 10 bcos 5*2 = 10

Is This Answer Correct ?    9 Yes 0 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / sirisha

5*2=10
Its a cartesian product

Is This Answer Correct ?    6 Yes 0 No

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing q..

Answer / v.g.venkatesh babu

It gives error. If you want to access the data from two tables then we must use JOINS concept... so we need to use aliasis names for tables...

* so both tables A and B must have same no. of fields with same datatypes then only we can use joins.

*Both tables must associated with forign key...

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What are few of the schema objects that are created using PL/SQL?

0 Answers  

What are the uses of sysdate and user keywords?

0 Answers  

What is rename in sql?

0 Answers  

What is bulk collections?

2 Answers  

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

What are local and global Indexes and where they are useful.

0 Answers  

What is the use of a view in sql?

0 Answers  

What found sql?

0 Answers  

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

What does pl sql developer do?

0 Answers  

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

How to Declare Fixed Length String Value In PL SQL

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories