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 / sirisha
5*2=10
Its a cartesian product
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is primary key and foreign key?
How do you remove duplicates without using distinct in sql?
How do you write a subquery?
What normalization means?
What is the purpose of cursors in pl/sql?
what is 'mysqld'? : Sql dba
What is union?
List and explain the different types of join clauses supported in ansi-standard sql?
Why cross join is used?
Show the cursor attributes of pl/sql.
How to assign sql query results to pl sql variables?
what is the difference between blob and text? : Sql dba
Does oracle roll back the transaction on an error?
Explain 3 basic parts of a trigger.
Differentiate between sga and pga.