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?

Answer Posted / mubin ahmad

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

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use like conditions? : Sql dba

786


What is the difference between rename and alias?

975


What is %type in sql?

693


Can 2 queries be executed simultaneously in a distributed database system?

865


Which type of cursor is used to execute the dml statement?

715






What are the possible values for the boolean data field?

695


what is query cache in mysql? : Sql dba

768


What is memory optimized table?

765


What is full join?

699


Explian rowid, rownum?

756


Can we rollback delete command?

697


Where is sql database stored?

689


How do you run a query?

768


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

760


Could you please provide oca (oracle 10g) dumps for my certification ?

4786