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 can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

What are different methods to trace the pl/sql code?

0 Answers  

What is sqlexception in java?

0 Answers  

What does the sign mean in sql?

0 Answers  

What is sql server and ase?

0 Answers  

What is the largest value that can be stored in a byte data field?

0 Answers  

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

What is procedure explain with program?

0 Answers  

How do you truncate?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories