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 the join types in tsql? : Transact sql

0 Answers  

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

Show how functions and procedures are called in a pl/sql block.

0 Answers  

What is dbo in sql?

0 Answers  

What is package in pl sql?

0 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

Why is stored procedure faster than query?

0 Answers  

What is data definition language?

0 Answers  

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

what are date and time functions in mysql? : Sql dba

0 Answers  

Explain foreign key in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories