Cartetian product i.e. 8 rows will be returned.

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF

SELECT * FROM EMP,DEPT;

Question Posted / shailesh

Answer Posted / shailesh

Is This Answer Correct ?

26 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are its different types of dbms?

955

What does varchar include?

905

What is trigger in flip flop?

955

How you improve the performance of sql*loader? : aql loader

954

How do you bind variables in pl sql?

1033

What is a pl/sql block?

1107

What is difference between cursor and trigger?

1015

Is a secondary key the same as a foreign key?

952

What are character functions in sql?

891

What is the difference between Union and Union all. Which is faster.

1340

How to run sql commands in sql*plus?

1080

who introduced sql?

947

what is a constraint? : Sql dba

1101

How to process query result in pl/sql?

1058

What is the best sql course?

928