5*2=10 Its a cartesian product

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 / sirisha

7 Answers
14131 Views
Cognizant, I also Faced
E-Mail Answers

Answer Posted / sirisha

5*2=10
Its a cartesian product

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2277

What is sql catalog?

1012

What is raid? How does it help storage of databases?

1078

Is clustered index a primary key?

945

Explain autonomous transaction.

1152

Explain table and field in sql?

1060

What is the difference between nested table and varray?

997

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1094

How do I trace sql profiler?

967

What is the sql case statement?

993

What are the different set operators available in sql?

1019

What is the difference between inner join and outer join?

988

What does := mean in pl sql?

1038

What is data control language (dcl)?

1131

Explain the uses of a database trigger?

1037