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

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

Can we rollback delete command?

0 Answers  

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

What is trigger point?

0 Answers  

What are different joins used in sql?

0 Answers  

Explain the structure of pl/sql in brief.

0 Answers  

What is sql analyzer?

0 Answers  

How do I order columns in sql?

0 Answers  

Is sql a microsoft product?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories